Combine two query into one (1 Viewer)

luzz

Registered User.
Local time
Today, 09:24
Joined
Aug 23, 2017
Messages
346
Hi all, I would like to ask how to combine two different query into one?

I have a union query and I would like to combine it with another query.
I have attached images of the two query above.

The purpose of combining these two queries is to use it in creating a report.
The end result i hope to achieve with this query should include the fabrication, remarks together with the union query.
 

Attachments

  • Union Query.png
    Union Query.png
    57.6 KB · Views: 57
  • SecondQuery.png
    SecondQuery.png
    81.3 KB · Views: 56

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:24
Joined
Feb 19, 2002
Messages
42,970
What do you want the result to look like?
 

luzz

Registered User.
Local time
Today, 09:24
Joined
Aug 23, 2017
Messages
346
What do you want the result to look like?

I want the result to have two column heading called Fabrication, Remarks. Then the size should match to the correct fabrication and remarks
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:24
Joined
Feb 19, 2002
Messages
42,970
Taking the data in the two pictures, please put it together so we can see what the desired output looks like. Your description is too cryptic.
 

luzz

Registered User.
Local time
Today, 09:24
Joined
Aug 23, 2017
Messages
346
Taking the data in the two pictures, please put it together so we can see what the desired output looks like. Your description is too cryptic.

Ok, I have attached an image of my desired output.
 

Attachments

  • endresult.png
    endresult.png
    10 KB · Views: 48

Users who are viewing this thread

Top Bottom