Re: Help with year to month converson
- From: "Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 23 Oct 2005 18:47:15 -0700
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
>
>
.
- Follow-Ups:
- Re: Help with year to month converson
- From: John Erickson
- Re: Help with year to month converson
- Prev by Date: Re: centering data within a field
- Next by Date: Re: Calculating elapsed time
- Previous by thread: Re: centering data within a field
- Next by thread: Re: Help with year to month converson
- Index(es):
Relevant Pages
|
