Re: How to for a report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You could create a form with a combo box on it. The combo box would be
based on a query that finds account numbers. You would add a command button
to open the report.

Then you'd base your report on another query, one that "looks" to the form's
combo box for the selection criterion for the account number field.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"frustratedwthis" <frustratedwthis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:C98257C6-55D0-434A-BA9F-35D38E37B42A@xxxxxxxxxxxxxxxx
I have 3 tables and many forms in my database. I would like to have a
report
that you can put in a certain account #, vendor ID, etc. and print a
report
just for that criteria. I can build a report that shows ALL the
information
in the database, but I would like to be able to do it for one vendor or
one
account number. Can this be done?
Thanks in advance


.

Quantcast