If "Text"

[Ossama22]

hello guys ,

i have a simple question and i hope to find a solution here ,

I Have Column named location which contains payment method (Bank "Then Bank Name)Or(Cash)

i excel i used to do it as follows (If Location="Bank *","Bank","Cash")

but in access i faced a problem in (*) i dont knw how can i do it .

all i need is if location =Bank HSBC (For Example) ,"Bank","Cash"
i have more than 1 bank . (HSBC,CIB,etc)

any help how can i do it like in excel ?

 

[June7]

You have a field Location with bank name or "Cash"?

You want to calculate as "Cash" or "Bank" payment type?

IIf([Location] = "Cash", "Cash", "Bank")

 

[theDBguy]

Not sure I understand but how about?

Iff(Left(Location,4)="Bank","Bank","Cash")