A
Andree
Hi,
Did you create the report from the table or do a select
query first and create the report using a query? In a
query you can specify criteria for your report, and before
you print your report you can go into the query design and
specify the particular record you'd like to report on,
then run your report.
If your report is already created and you want to use the
query, you don't have to create a new report. Just open
the report in design view, click on Properties, and under
Data there should be an arrow that you can click on and a
drop down list of tables and queries appears where you can
choose the query you created. Then go back into print
preview and you should have your report.
There is a more complicated way to select particular
records each time you want to use your report. You'd have
to create a form that the query would specify that you go
to. The form would have criteria in it that you can click
on, and then it should take you to the report. That's a
different training.
Good luck!
Did you create the report from the table or do a select
query first and create the report using a query? In a
query you can specify criteria for your report, and before
you print your report you can go into the query design and
specify the particular record you'd like to report on,
then run your report.
If your report is already created and you want to use the
query, you don't have to create a new report. Just open
the report in design view, click on Properties, and under
Data there should be an arrow that you can click on and a
drop down list of tables and queries appears where you can
choose the query you created. Then go back into print
preview and you should have your report.
There is a more complicated way to select particular
records each time you want to use your report. You'd have
to create a form that the query would specify that you go
to. The form would have criteria in it that you can click
on, and then it should take you to the report. That's a
different training.
Good luck!