Consulting

Results 1 to 3 of 3

Thread: ACQUIRE DATA FROM TWO DIFFERENT QUERIES TO ONE REPORT.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Tutor GaryB's Avatar
    Joined
    Jun 2004
    Location
    Stockton, California
    Posts
    270
    Location

    ACQUIRE DATA FROM TWO DIFFERENT QUERIES TO ONE REPORT.

    I need help please!

    I have built a report that needs to draw the status as a job folder proceeds through the plant. The common sorting element to differentiate customers is the customer code. So in my query for the report under customer I have, example: like AAA The other fields in the query are job# - description - datedue - etc.... But even though the customer code exists in all 3 queries I am using for this report, they will only show the info for the queries I am using as the source for the customer code. I have attached a screen shot of the query.

    I know I am missing a basic here, so any help would be appreciated.

    Thanks,

    Gary
    Attached Files Attached Files

Posting Permissions

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