Sum two queres

[klynch0803]

What is the best way to get the difference between two queries?

I tried Union but dont get any results.

I tried Crosstab but that doesnt allow multiple queries.. Hmmm

So I tried the simple query and added both queries to it and right joined by Item and added the field "Qty" from the Recieved query and the "qty" from the usage query. I then created an Expression "[Received].[qty]-[Usage].[Qty]" but got no results it returned the value of received qty...

How in the world can I do this..?

 

[Jon K]

Can you post your database with some sample data? Preferably in Access 2000 format.
.

 

[klynch0803]

Can you post your database with some sample data? Preferably in Access 2000 format.
.

Here you go.. I have included two queries as well that collect the data individually but I cannot change the criterias in them cause they are used for another purpose as well..

There is three tables

"tdatInventoryList" List of Inventory
"tdatinventoryRec" Inventory Received
"TdatInventoryUsage" Inventory Used

I need to know what the balance of the inventory is currently. As for example the result for BudBtl should be "2"

 

[klynch0803]

Thank You but I figured it out..

The tdatInventoryUsage properties was set to lookup instead of text therefore it did not recognize like the tdatinventoryrec was...