Problems with IIF in query

[ducecoop]

Access 2003




I am trying to solve a problem from another post I made that had no solution
https://www.accessforums.net/access/...form-9241.html

I have added a field to a query that opens a continuous form

The new field is [PrivatePass]
I want that field to display the contents of the field [ComputerPassword]
unless the field [Privacy] (a yes/no field) is checked and then I want it to display *******

this is what I am using in the criteria of [PrivatePass]

IIf([Privacy]=True,"******",[ComputerPassword])

When I run the query I get 0 records

Any ideas?

tia

Dave

[ducecoop]

OK - I am officially an idiot

I put the IIF in the criteria instead of the field name.
Got it working now

thanks for reading