i have a Transactions table for recording product Sales and Purchases and want a Query to show a running balance for sales and purchases for each product.
i'm getting an error when trying to use the Dsum function below: (Type is product type and Tdate is transaction date)
balance: DSum("Purchased"," [TblTransactions]","[TblTransactions]![Type]"=[Type] And "[TblTransactions]![Tdate]"<=[Tdate])
is there a better way to to do this?
i'm getting an error when trying to use the Dsum function below: (Type is product type and Tdate is transaction date)
balance: DSum("Purchased"," [TblTransactions]","[TblTransactions]![Type]"=[Type] And "[TblTransactions]![Tdate]"<=[Tdate])
is there a better way to to do this?