Hmmm.
??Where does StockLevel come from in this query
Code:
SELECT tblProduct.ProductID, tblProduct.Description
, tblProduct.StockLevel AS Expr21, tblProduct.ReorderLevel
, [tblProduct]!StockLevel-[tblProduct]!ReorderLevel AS Expr1
FROM tblProduct;
I changed Expr1 to Expr21 because of the duplicate outputs.
What was your initial approach to designing this application?
Tables and relationships from business description OR
Forms to approximate/respond to Telephone scenario above.
Maybe someone else has followed your thread and has answers to your specific issue