selecting specific output for reports

[grod555]

Hi,
I am beginner access user.
I have created a report but would like to limit the records that are printed.
Selection (filter) is either by date or name.
How can I set it up to request the data from the User and then print the report accordingly.
Thank for your support in advance...
Regards

 

[scriverb]

Rather than have the Record Source for your report be the table you should create a query with the table being the source of your records, select all of the fields for the report, and enter a prompted criteria entry in the columns to be selected on.

Example:
SELECT tblYourTable.Name, tblYourTable.Date, tblYourTable.Address, tblYourTable.City, tblYourTable.State, tblYourTable.ZipCode
FROM tblYourTable
WHERE (((tblYourTable.Name)=[Enter Name: ]) AND ((tblYourTable.Date)=[Enter Date: ]));

Make the necessary changes to this example and change the Recordsource of your report to this query. When running the report the query will prompt you for the Name first and then the Date. After entering these it will select only records matching the entries and print the report with only those rows showing.

Good luck with your project.
Bob Scriver