Access Formula 1

[CCPKGUY]

I am creating a query and I added a column to show the actual payment type. Fo example the Pay Methods are

1 - Cash
3 - Debit
4 - Money Order
6 - Online Payment

When I try to build this I am getting PAYMENT TYPE: IIf([harris_live_ichrecpt]![pay_method])="1","Cash") which does not seem to work. Any suggestions??

 

[SkipVought]

hi,

"1" and the number 1 are entirely different values!
[tt]
IIf([harris_live_ichrecpt]![pay_method])=1,"Cash")
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

Don't you have a small Payment Type lookup table? I wouldn't hard-code any values into an IIf() expression.

Duane
Hook'D on Access
MS Access MVP