Preview multiple reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Simple database and with some help on here the past few days I am 99% done.
I have a "Request For Quote" database.
On the form you toss in quote number, quantity, project, descrip.
I have 4 spots as of now to in put 4 vendors (which is being pulled from
another table). Everything is great.
I created a query in which I use this statement:
Like "*" & [Quote Number] & "*"
I want to save all these quotes entered and to view a individual report. So
I hit the report and it asks for quote number. I enter it and BAM it's all
there.
Right now it shows all 4 vendors on the report which is good because we need
to see that. However we need to fax this to our vendors and don't want vendor
1 to see vendor 2.
So I made 4 more reports (copied from the main one) where rptVen1 shows Ven
1, and rptVen2 shows only ven 2, etc... the other vendors are greyed out.
It'sthe format we have now (the greyed out portion because of carbon copy).
Is there a way to hit a button and have all 4 come up with out it asking me
4 times the quote number? If I can get all 4 open and just click
file/print/fax (fax is automated) and then go to the next and do the same.
Right now the button opens 4, but I have to type in the number for each
report.
Right now it appears they have 2 choices: Type the quote number in 4 times
(one for each report) or have 4 report buttons.
Any suggestions on how to simply this?

Thanks
 
Leave the form open where you entered the quote number and have report query
use it as criteria.

Jerid B said:
Simple database and with some help on here the past few days I am 99% done.
I have a "Request For Quote" database.
On the form you toss in quote number, quantity, project, descrip.
I have 4 spots as of now to in put 4 vendors (which is being pulled from
another table). Everything is great.
I created a query in which I use this statement:
Like "*" & [Quote Number] & "*"
I want to save all these quotes entered and to view a individual report. So
I hit the report and it asks for quote number. I enter it and BAM it's all
there.
Right now it shows all 4 vendors on the report which is good because we need
to see that. However we need to fax this to our vendors and don't want vendor
1 to see vendor 2.
So I made 4 more reports (copied from the main one) where rptVen1 shows Ven
1, and rptVen2 shows only ven 2, etc... the other vendors are greyed out.
It'sthe format we have now (the greyed out portion because of carbon copy).
Is there a way to hit a button and have all 4 come up with out it asking me
4 times the quote number? If I can get all 4 open and just click
file/print/fax (fax is automated) and then go to the next and do the same.
Right now the button opens 4, but I have to type in the number for each
report.
Right now it appears they have 2 choices: Type the quote number in 4 times
(one for each report) or have 4 report buttons.
Any suggestions on how to simply this?

Thanks
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help showing results 6
Access Sorting and grouping using multiple tables 0
creating a report with Access 1
MRV reuses number 1
Subform causing duplicate records? 7
Build search function in to a form 5
I am getting blank results due to unfilled field 8
Multiple Vendors for products - Table relationships 4

Back
Top