heeeeeeeeeelp

[abosamra]

this is me again
i am facing a problem with my report
i created a report related to one of my tables
but when i tried to print it will print all the record
there is any way to tell access which report i would like to view and print
please any help

 

[addy]

If you have a report linked directly to a table and don't apply any filtering in your report it will print every record from your table.

I usually base my reports on a query so I can apply filtering if required more easily.

Create a query based on the table you are reporting on and then you can add your filter criteria directly to the query, or have the query prompt your for parameters, for example, if you had a date field in your table and you wanted to report on a certain date range, you could add the following as the Criteria for the date field in your query:

Between #[Enter Start Date]# And #[Enter End Date]#

When you open the report, you would be prompted to enter two dates which would filter your report.

 

[Rich]

Use the Where clause of the OpenReport method

 

[abosamra]

dear addy
it's working fine now
now i can view and print by specific record number
many thanks