Re: Help with year to month converson

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jeff

Thats pretty much it. The contract can be from a period of not less than 1
month to not greater than 12 months. The only time it is different is when
the client signs a contract in the middle of the month and the first and
last months are prorated ( the prorated amount is the same for both the
first and last month then). What I would ultimatly like to do is generate a
report that looks at the calendar year.

John

"Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23jHUn9I2FHA.1332@xxxxxxxxxxxxxxxxxxxxxxx
> 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
    ... you have startdate, enddate, amount, right? ... The contract can be from a period of not less than 1 ... >> Jeff Boyce ...
    (microsoft.public.access.gettingstarted)
  • 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: Help with year to month converson
    ... Are you saying that the amount is calculated by dividing the contract total ... Regards ... >> Jeff Boyce ...
    (microsoft.public.access.gettingstarted)