Two Queries into one report 1

[chanman525]

Hey all. I've got two queries that are virtually the same. They both show the exact same information, but their criteria is just a little different. (One was needed to show certain picks in the building, and the other one a different set of picks). Anyway, I'm trying to find a way to get both queries into the same report. I built a union query which shows all of the information in one query, but I can't seem to get it into the report.

Does anyone have any tips or ideas on what I could do?

Thanks.

Alg

 

[dhookom]

Why can't you get it into the report? Did you set up the Record Source as the union query?

What are your results?

Duane
Hook'D on Access
MS Access MVP

 

[chanman525]

I got it taken care of. I was doing something really stupid. Long day.

Thanks for the response.

 

[chanman525]

I do have a problem though now. The top two items in my query are "Crossdock", the bottom two are "Warehouse"

I don't see a way that I can separate these out at all to distinguish between the two. If I put the labelbox in the detail part of the report, each label box will show up 4 times.

I'm basically looking for something like this...

Crossdock Warehouse

100 PIck Complete 200 Pick Complete
200 Diverted 100 Diverted

 

[dhookom]

Can you be more specific? What's an "item"? What is "top" or "bottom"? What's a "labelbox"?

Are you attempting to "separate" something that you have just unioned?

Duane
Hook'D on Access
MS Access MVP

 

[chanman525]

I got it last night.

Thanks for your help dhookom