Assigning text response to a value

[cowichandave]

In quering a sales database, if the sales amount is positive how do I get the
query to add "Sale" in another field or if the sales is negative have it add
"Refund" in the another field

 

[Marshall Barton]

In quering a sales database, if the sales amount is positive how do I get the
query to add "Sale" in another field or if the sales is negative have it add
"Refund" in the another field

Try adding a calculated field to the query. Just put an
expression like:
IIf([sales amount<0,"Refund","Sale")
in a blank column in query's design view.

 

[KARL DEWEY]

Try this --
Type_Action: IIF(Nz([Money], "Error")>1, "Sale", "Refund")

 

[cowichandave]

Thank you both. I used Marshalls simpler answer and it works very well.
--
CowichanDave

In quering a sales database, if the sales amount is positive how do I get the
query to add "Sale" in another field or if the sales is negative have it add
"Refund" in the another field

Try adding a calculated field to the query. Just put an
expression like:
IIf([sales amount<0,"Refund","Sale")
in a blank column in query's design view.