G Guest Dec 1, 2004 #1 How do I write a query or something to show that if two fields added together equal another field then mark inactive?
How do I write a query or something to show that if two fields added together equal another field then mark inactive?
A Arvin Meyer Dec 1, 2004 #2 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
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
G Guest Dec 1, 2004 #3 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...
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...
