running reports based on specific criteria

  • Thread starter Thread starter matthew perry
  • Start date Start date
M

matthew perry

Hello,

I have created a database and at the moment it only contains tables and
forms. I am trying to create various reports now and am looking for some
assistance. As most of my tables have thousands of rows in them i would like
to create a report which allows me to filter for different customers so that
the reports is not 1500 pages long.. at the moment there is a report on the
database which was part of the original template i used which allows date
ranges to be entered to filter the data. this is what i want but for
customer name. What confuses me is that there is no query set up for this
report date range and from looking at some posts on here i can see that you
mention queries. Can someone please advise me how i can create a report
which is able to filter for customer names.

many thanks

Matthew
 
Create a form where the user can select the record to print, or specify the
date range. The Click event of a button on that form can then open the
report limited to just the matching records.

For a simple example, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

For an example involving a date period (week, month, whatever), see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

For a more complex example involving lots of criteria, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
This example actually filters the form to display the results, but filtering
the report is identical.
 
thanks very much for your help.

Allen Browne said:
Create a form where the user can select the record to print, or specify
the date range. The Click event of a button on that form can then open the
report limited to just the matching records.

For a simple example, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

For an example involving a date period (week, month, whatever), see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

For a more complex example involving lots of criteria, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
This example actually filters the form to display the results, but
filtering the report is identical.
Click to expand...
 
Back
Top