Reports based on Criteria

  • Thread starter Thread starter Ian P
  • Start date Start date
I

Ian P

Hi,

New to Access, this is my first DB.
I need to be able to print various reports based on
criteria that Access will prompt the user for.

E.G. list all records created between (start date) and
(end date)

how can I achieve this?
 
Ian said:
Hi,

New to Access, this is my first DB.
I need to be able to print various reports based on
criteria that Access will prompt the user for.

E.G. list all records created between (start date) and
(end date)

how can I achieve this?
Click to expand...
Ian,
Make a query the record source for the report.
In the query, set the criteria of the [DateField] to:
Between [Enter Start Date] and [Enter End Date]

The user will be prompted for the dates.
 
Thanks a lot! that worked great.

Cheers
Ian
-----Original Message-----
Ian said:
Hi,

New to Access, this is my first DB.
I need to be able to print various reports based on
criteria that Access will prompt the user for.

E.G. list all records created between (start date) and
(end date)

how can I achieve this?
Click to expand...
Ian,
Make a query the record source for the report.
In the query, set the criteria of the [DateField] to:
Between [Enter Start Date] and [Enter End Date]

The user will be prompted for the dates.
--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
.
Click to expand...
 
Back
Top