IF statment criteria??

[cthai]

Hello -

I'm completely new to programing in access and i'm running into an issue with an If statement not sure how to go about it -

i have a table with a million different fields in there -i have separated the fields by doing something like this

type: IIf([typeclear]="ts" Or [typeclear]="s",1)
field: IIF([([field1]="ccb" Or [field1]="ssbi-pr",1)

Now i have a date field called finaldate -

i want to say something like if type and field1 = to 1 use finaldate.



how do i go around doing this?

[AccessPonderer]

You're almost there.

I think you can simply use brackets and an AND clause:

SELECT IIf( ([typeclear]="ts" Or [typeclear]="s")  AND ([field1]="ccb" Or [field1]="ssbi-pr"), FinalDate, otherChoice)
FROM yourTable

where otherChoice is what you want when those things are not true.

Let us know if that's not what you want.