Combining the results of 2 queries into one for a report

[Carlton]

I have one query that pulls information from deliveries and sites tables and needs to divide the deliveries in half. Then I have another query that pulls information from the same tables about another product but I need to combine these results, which involves both kinds of deliveries to the same site. I can't get it to combine the results. Any ideas?

[June7]

Don't understand 'divide the deliveries in half'.

Why can't you just apply filter for both products in one query?

What do you mean by 'combine' - UNION, JOIN?

[Carlton]

You're right. I read up on the different joins and I think that's where the answer lies for my problem. The deliveries that need dividing are entered into a table and can only be used half with one product and half with another. Thanks for your efforts and thoughts on this.