Reports based on Criteria

[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?

 

[fredg]

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,
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.

 

[Ian P]

Thanks a lot! that worked great.

Cheers
Ian

-----Original Message-----

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,
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.
.