running reports based on specific criteria

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"matthew perry" wrote in message
...

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

thanks very much for your help.

"Allen Browne" wrote in message
...
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"matthew perry" wrote in message
...

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