IF...ELSE In MS Access 2000 Queries

  • Thread starter Thread starter CS
  • Start date Start date
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
 
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])
 
Back
Top