Show Inactive

S

Stacey

How do I write a query or something to show that if two fields added together
equal another field then mark inactive?
 
S

Stacey

Arvin-

How will it automatically mark them inactive then?

This is what I have in the first criteria field in the Query I did:
If([101504].Amt_paid+[101504].[W/O_Amt]),("Inactive","Active") As
[101504].Amt_due

Basically if Amt_paid + W/O_Amt equals Amt_due, I don't want it to show that
field in the query or report.


Arvin Meyer said:
Select IIf([Field1]+[Field2), "Inactive","Active") As Field3
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Stacey said:
How do I write a query or something to show that if two fields added together
equal another field then mark inactive?
Click to expand...
Click to expand...
 
Top