Calculated result of two different queries.

E

Eyal

Hi There.
I have 2 tables , one called "details of orders" and the second called
"Stock on hand" each table has 7 input felids , 1.Style number(Numeric)
2.Colour (Text) 3.Small (Numeric) 4.Medium (Numeric) 5.Large (Numeric)
6.XLarge (Numeric) 7.XXLarge (Numeric). Each table hasn’t got the exact
details as far as quantities on hand. I created a query for each table to
sort and summarize each table. I need to create a report taking the
quantities from "orders on hand" and subtract the Quantities from "Stock on
hand". If I create a query that includes both tables the results (quantities
are totally wrong) any suggestion?
 

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 result of two querirs 1
Query from two tables 2
printing results of 2 queries 4
Advice for field structure or query structure - not getting theresults I thought I should 3
How do I group identical records? 2
Report from two queries 4
Access 2007 0
Eliminate repeat values in one field 7

Top