individual reports

  • Thread starter Thread starter Momof2
  • Start date Start date
M

Momof2

I have created my 1st database which is designed to track missing receipts
from individual credit card statements. It does pretty much everything I want
it to do except for one little thing that I can not figure out. I have
several 100 people in which I'm tracking back from 2006. I have created a
report which breaks down by individual what is missing. I am trying to figure
out a way in which I can just select the individual I want to run the report
for instead of it pulling up everyones information. I'm sure this can be done
just not sure where to start.
 
Let's assume you are working on a form to do this.

Add a combobox that lists the folks for whom you want to do this.

Add a <PrintPreview> command button that opens the report.

The report is based on a query, not directly on the table.

The query that feeds the report points at the form to get a selection
criterion for the ID of the person.

Alternatively, you can use a report that WOULD display all folks' data, but
behind the command button, have the report open with a WHERE clause or
filter (again, using the value selected in the combobox).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top