Displaying data in a form and or report

[Eyal]

I have a table of "stock items "(Style Number, Colours & 5 different sizes).
I have another table of "orders on hand" with (Style Number, Colours & 5
different sizes).
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).
Any suggestions
Many thanks
Eyal

 

[Jeff Boyce]

Eyal

From your description, it sounds like you have two "spreadsheets", each with
a list of items. One of the "tables" is stock items and the other is orders
on hand.

If this is what you have, why are you using Access? A spreadsheet like
Excel keep two 'sheets without all the overhead and learning involved in
getting Access to do what you want.

On the other hand, if you want to get good (and easy) use of MS Access,
you'll need to consider changing how you're storing the data. Take a look
at the Northwind sample db that comes with Access for ideas about design.

Regards

Jeff Boyce
Microsoft Office/Access MVP