Generating forms by date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 18 Jul 2005 08:01 GMT

Hello

I need to be able to generate a report by date, or better still by month. I
am setting up a loan application tracker and need to display loan settled for
one month at a time.

Can anyone help me with this???

Reply to this Message

John Vinson - 18 Jul 2005 18:08 GMT

>Hello
>
[quoted text clipped - 3 lines]
>
>Can anyone help me with this???

Create a Query with a criterion on the date field to return the
desired date or date range; base your report on this Query.

You might want to use a criterion like

>= DateSerial([Enter year:], [Enter month number:], 1) AND < DateSerial([Enter year:], [Enter month number:] + 1, 1)

The user would type in 2005 in response to Enter Year:, 5 in response
to Enter Month Number:, and would see all records for May 2005.

John W. Vinson[MVP]

Reply to this Message