displaying result of two querirs

  • Thread starter Thread starter Eyal
  • Start date Start date
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
 
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
 
Back
Top