Sum of Inventory (Sum Feilds in Query)

Y

Yaac

I have an inventory table with the following feilds

InventoryTransactionID
ProductID
UnitsReceived
UnitsSold
UnitsShrinkage

I would like to create a query to give me an inventory for each product that
i can reference to in a UnitsInStock control in a Product form.

I have tried the following with no success. What am i doing wrong?

UnitsInStock : =Sum(nz([UnitsReceived])-nz([UnitsShrinkage])-nz([UnitsSold]))

I get this error "You tried to execute a query that does not include the
specified expression <name> as part of an aggregate function." (Error 3122)

Thanks for any help you can give me.
 

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

Inventory 0
Displaying records with a zero value 6
Not showing records in a report that have a calculated 0 value 5
calculating quantities 5
Can not update records based on two queries 6
Inventory Control Database Calculations 1
Not able to pull up record on query 0
Query will not pull up new records? Can anyone figure what's going 0

Top