MS Access Query
How do you add records horizontally to an existing query? In the example below, how do you add the book column from query 2 to the existing query 1?
Here is a brief example:
Query 1:
Recipe Date
Cake 1-1-15
Query 2:
Recipe Book
Cake Betty Crocker
Desired Result:
Recipe Date Book
Cake 1-1-15 Betty Crocker
Here is a brief example:
Query 1:
Recipe Date
Cake 1-1-15
Query 2:
Recipe Book
Cake Betty Crocker
Desired Result:
Recipe Date Book
Cake 1-1-15 Betty Crocker
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER