displaying result of two querirs

E

Eyal

I have a table of "stock items "(Style Number, Colours & 5 different sizes
(S-XXL)).
I have another table of "orders on hand" with (Style Number, Colours & 5
different sizes (S-XXL)).
I have two different queries to sort the results of the two tables.
I want to create a report that will display the result of the one table
(stock) less the result of the other table (Orders on hand) in the same
breakdown as the tables (Style Number, Colours & 5 different sizes (S-XXL)).
Any suggestions
Many thanks
Eyal
 
J

Jeff Boyce

Already responded to in the other newsgroup you posted to.

Rather than submitting a question/post to each newsgroup independently,
create a single post and post to the relevant newgroup(s).

NOTE: it is rarely necessary to post to more than one.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying data in a form and or report 1
printing results of 2 queries 4
Calculated result of two different queries. 1
ALLOCATION OF ORDERS - Pivot table 7
Multiple reporting 2
Sequentially numbered stock cards 1
splitting field data 3
Access Stock In Hand query in access 2007 0

Top