Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page