Hello,
I know this will probably be a quick question for someone with good knowledge with Access Query's. I am trying to make a query that will calculate fields like this--
Expr1:
IF ([Job Type]="Audit" OR "AuditNTX" THEN [PropAudit]-[Discount Amount])
ELSE
IF ([Job Type="Review" OR "ReviewNTX" THEN [PropReview]-[Discount Amount])
ELSE
IF ([Job Type]="TaxOnly" THEN [TaxOnly]-[Discount Amount])
ELSE
[OtherAmount]-[Discount Amount]
Any ideas how I should write this as an expression in a query? Help would be much appreciated. Thank you in advance--
Akaisar
I know this will probably be a quick question for someone with good knowledge with Access Query's. I am trying to make a query that will calculate fields like this--
Expr1:
IF ([Job Type]="Audit" OR "AuditNTX" THEN [PropAudit]-[Discount Amount])
ELSE
IF ([Job Type="Review" OR "ReviewNTX" THEN [PropReview]-[Discount Amount])
ELSE
IF ([Job Type]="TaxOnly" THEN [TaxOnly]-[Discount Amount])
ELSE
[OtherAmount]-[Discount Amount]
Any ideas how I should write this as an expression in a query? Help would be much appreciated. Thank you in advance--
Akaisar