Multiple Queries in A Report

T

Tara

I have been trying for days but I am not that educated on Access. I have two
queries that each take different product names and attach them the customers
table and also attach to the product prices. I had to create two different
pricing tables..too long to explain. However, the queries are working great
but when I try to put it them into a report, there is no information there!
Just the field labels....HELP, I am going crazy. I has to be something
simple but I can't seem to figure it out!

Thanks Tara
 
F

fredg

I have been trying for days but I am not that educated on Access. I have two
queries that each take different product names and attach them the customers
table and also attach to the product prices. I had to create two different
pricing tables..too long to explain. However, the queries are working great
but when I try to put it them into a report, there is no information there!
Just the field labels....HELP, I am going crazy. I has to be something
simple but I can't seem to figure it out!

Thanks Tara
Click to expand...

A Report can only have one record source.
If you have 2 separate queries, combine them into third query.
Make sure all the joins and relationships are correct.
Make that the report's record source.
 
Top