Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Teas
    Posts
    28

    Red face Unanswered: multiple queries for one report ..... is it possible ???????

    I have four queries like count type and basically i am doing this to show summary on a report. Is there a way i can put all this query on one report.

    Report goes like this.

    Summary:
    - Total Received after due date (which is we just did)
    - Total Census for Plan Year End (count)
    - Total Census Complete (count)
    - Total Outstanding (count)

    Thanks for helping me.
    Last edited by cool_guy_no_1; 09-16-03 at 01:15.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Wink

    With and Union Query.
    Saludos
    Norberto

  3. #3
    Join Date
    May 2003
    Location
    Teas
    Posts
    28

    How???

    I have never done Union Query but I am gonna try your suggession. Thanks for your reply. Would you please post a sample database, If you have a sample database with union type query? That way I know what kind of result it spits.

    Thanks
    Dianna Jamil

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    I send for you a Sample.mdb with union type query.
    Attached Files Attached Files
    Saludos
    Norberto

  5. #5
    Join Date
    May 2003
    Location
    Teas
    Posts
    28

    I will try that...

    thank you and i will try you method. thanks a lot.

Posting Permissions

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