Re: Help with year to month converson

John

Are you saying that the amount is calculated by dividing the contract total
by the number of months in the contract?

--
Regards

Jeff Boyce
<Office/Access MVP>

"John Erickson" <noone@xxxxxxxxxxx> wrote in message
news:uvihcgE2FHA.3756@xxxxxxxxxxxxxxxxxxxxxxx
> Jeff
>
> If I were doing it with paper and pencil, I would know the amount to
charge
> by the month. As an example, if the contract started on jan 1 and ended on
> dec 31 and the total amount of the contract was $1200, I would know that
we
> would bill out $100 a month from Jan to Dec. I have set up a query that
will
> give me the amount that we charge per month ( that part was easy).
>
> Thanks
> John
>
> "Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:%238ZEXxD2FHA.3864@xxxxxxxxxxxxxxxxxxxxxxx
> > John
> >
> > It sounds like you know a start date, an end date, and the current date.
> > Access has date-related functions that let you determine the month of a
> > given date.
> >
> > If you were doing this with paper & pencil, how would you describe how
you
> > determine a bill?
> >
> > --
> > Regards
> >
> > Jeff Boyce
> > <Office/Access MVP>
> >
> > "John Erickson" <noone@xxxxxxxxxxx> wrote in message
> > news:O5SNbWD2FHA.2056@xxxxxxxxxxxxxxxxxxxxxxx
> >> Hi all
> >>
> >> I am currently in the process of setting up database to help us with
> >> billing. The information that I get from the sales reps is the date the
> >> contract starts, that date it expires and the total amount of the
> > contract.
> >> The problem is we bill by them month. I was wondering if there is a way
> >> to
> >> generate a monthly report just using the information at hand, or would
it
> > be
> >> better to breakdown the amount entered by the month on the form.
> >>
> >> Any help would be greatly appreciated.
> >>
> >> Thanks
> >> John
> >>
> >>
> >
>
>

.

Relevant Pages

  • Re: I Saw Barack Obama Today
    ... A bill to prohibit deceptive practices in Federal elections ... A bill to amend the Clean Air Act to reduce greenhouse gas ... and the aggregate amount of the contributions ... contract personnel under Federal contracts, ...
    (rec.sport.football.college)
  • Re: I Saw Barack Obama Today
    ... A bill to prohibit deceptive practices in Federal elections ... A bill to amend the Clean Air Act to reduce greenhouse gas ... and the aggregate amount of the contributions ... contract personnel under Federal contracts, ...
    (rec.sport.football.college)
  • Re: Help with year to month converson
    ... We havent yet had an occasion where there was an exception to ... to perform these calculations for me. ... I do have the start date, end date and total amount, and if the contract is ...
    (microsoft.public.access.gettingstarted)
  • Re: McLaren verdict
    ... don't have constructor points to worry about any more. ... contract" idea - as there's no constructors' points up for grabs, ... so there might be a certain amount of ... Whilst Alonso has looked bad in all this and my opinion of the guy is ...
    (rec.autos.sport.f1.moderated)
  • RE: Calculate total interest earned on a loan and monthly payment
    ... Contract divided by two), the number of months in A2 and the APR in A3. ... To begin with, Excel displays the result of the PMT function as a negative, ... this will give you the amount repayable each month to your contractor. ... principle to be paid, to arrive at the interest portion of the ...
    (microsoft.public.excel.worksheet.functions)
Loading