ACQUIRE DATA FROM TWO DIFFERENT QUERIES TO ONE REPORT.

[GaryB]

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

[jonh]

Sorry, I don't understand any of the above. "Customer" being SalesRep?
If so you are using Like in your query without wildcards.
Like "A2Z" is no different to just writing "A2Z", without the like.
e.g. If you want sales reps that begin A2Z you write, like "A2Z*"

[GaryB]

Sorry, I don't understand any of the above. "Customer" being SalesRep?
If so you are using Like in your query without wildcards.
Like "A2Z" is no different to just writing "A2Z", without the like.
e.g. If you want sales reps that begin A2Z you write, like "A2Z*"

Thanks for the reply. The like and the A2z were just an example and I apologize if it was confusing. However, I did work it out. Fortunately I had a query that had everything I needed and I was able to use the other 3 queries as filters to net what I needed.

Thanks,

Gary