Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Preview multiple reports

Discussion in 'Information Technology' started by Jerid B, Jul 28, 2006.

  1. Jerid B

    Jerid B
    Expand Collapse
    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
     
  2. Loading...


  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

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

    "Jerid B" wrote:

    > 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
     

Share This Page