Query Issue: Enter Parameter Value

[striker73]

I have a query that has the following field:

Planned_Test_Date = IIf(IsDate([TestDate]),[TestDate],"else")

The TestDate field is a date field that is sometimes null. When I display the table, it looks like all of the entries are either a date field or null, so the data is fine.

When I run the query, I get a window that pops up and says "Enter Parameter Value Planned_Test_Date. In my experience, this happens when you are referring to a field that doesn't exist.

Can someone help me out? Thanks!

 

[Blorf]

Planned_Test_Date = IIf(IsDate([TestDate]),[TestDate],"else")

Your field [TestDate] is a field in one of your tables yes? So reference it by table by changing [testdate] to [YourTableName].[TestDate].

Hope that works,
ChaZ

 

[PHV]

If in query grid, replace the = (equal sign) by : (colon).
Don't sure access will not choke on "else", something like type mismatch.
You may consider this:
Planned_Test_Date: Nz([TestDate])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244