Re: Help with year to month converson

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: 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)
  • 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)