IIf statement or If .. Else Query 1

[darinmc]

Hi
I have a query, in the one field, I have the below statement, however i need to make it more complex, like an if...else statement

Desc: [EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate"

I would like it to show:

ON ALL RECORDS
Desc: [EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate"

(EXCEPT) BUT if [clientRegNo]=1 then

Desc: [EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate - (" & [EmpPinNo] & ")"

OR USING IIf, something like:

Desc: IIf([clientRegNo]=1, "[EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate - (" & [EmpPinNo] & ")"", "[EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate"")


Hope u can help
Thx
Darin

 

[darinmc]

I managed to get it to work using simiar code, I must have had comas or something wrong PLUS I had to change ClientRegNo to reflect [TESTjobs].[ClientRegNo]

Desc: IIf([TESTjobs].[clientRegNo]=1,[EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate - (" & [EmpPinNo] & ")",[EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate")

Thx Anyway
Darin

 

[PHV]

A simpler way:

Desc: [EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate" & IIf([TESTjobs].[clientRegNo]=1," - (" & [EmpPinNo] & ")","")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886