IF...ELSE In MS Access 2000 Queries

T

tina

suggest you use the IIf() function, syntax is
IIf(statement is true, then use this value, otherwise use this value)
example
IIf(FieldA Is Null, 0, FieldA)

hth
 
F

Frank Stone

Yes use the IIf function. Put it in the query header. here
is one i used to get information our of table WODates if
condition is true or get imformation out of linked table
dbo_WKO if condition is false. "Status" will be the column
header.

Status: IIf(IsNull([WODates]![Issue Date]) And [dbo_WKO]!
[WKO_StatusCode]="Released",[dbo_WKO]!
[WKO_StatusCode],"Issued" & "-" & [WODates]![Issue Date])
 
Top