Becky Edwards
asked on
Subtracting one records field from another. Mar06-Feb06 (variance)
I have two fields with data in them. I want to create a query, add the two fields, and then subtract one from the other. I don't know how to do it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AddFields: (DateField1 + DateField2)
Same for subtracting them:
SubtractFields: DateField1 - DateField2
This would result in your query having two new fields - one named AddFields and one named SubtractFields.
If either of these could contain Null values, you'd want to use the Nz function:
AddFields: (Nz(DateField1,0) + Nz(DateField2, 0))