Dear All,
Who can help me with a formula within Access?
I do not get the correct result with the formula below, the total amount is not correct or I get an error message.
=Nz([frmOrderDetails].[Form]![Qty]*[frmOrderDetails].[Form]![lstprice]) = result = 720 euro
=Sum(Nz([frmOrderDetails].[Form]![Price])) = error
Bookmarks