Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    London, Kent, England
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report info exchange (Access 97)-MULTI-Report info exchange (A

    I have two separate queries. and then 2 crosstab queries coming from these. Then, 2 reports.
    Eg:
    Query 1 x tab
    Bread Fish

    Name 2 1

    Query 2 x tab
    A B C
    Name 5 2 1

    What i need to do, in One of the reports is take information from the other report and then do some math on it .. ie: in the example above, 2 bread purchased, compared with A column, then do 2 out of 5 = 40%

    So what i need to do (I think) is take information from one report and do some math on it in a separate report. I don;t know whether i need to do this at the query stage, or the report stage.
    Help !
    TIA
    Mora

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Report info exchange (A

    Do it at the query level.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •