Generating forms by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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???
Click to expand...

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)
Click to expand...

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]
 
Back
Top