Using Expression Builder in Query

[The Sharkster]

I am trying to use Expression Builder in a Query to build a test plan selector tool for our engineering department. My expression is as follows:

IIf([Heights mm] = 650, "Newborn", "*")

This keeps returning the false value no matter what is select in my Lookup column [Heights mm]

Any suggestions are greatly appreciated.

 

[MSAccessRookie]

I am trying to use Expression Builder in a Query to build a test plan selector tool for our engineering department. My expression is as follows:

IIf([Heights mm] = 650, "Newborn", "*")

This keeps returning the false value no matter what is select in my Lookup column [Heights mm]

Any suggestions are greatly appreciated.

I am not sure where you are going with this, but one thing that I noticed is that the only TRUE value for the formula is when the value of [Heights mm] is exactly 650. Perhaps you meant <= 650 ?

 

[The Sharkster]

Actually I want it to return a True for any in a selected group of predetermined Heights mm depending upon what I select in my query lookup column. I wanted to start simple and see if I could get it to perform one small task. Basically I want my field to say "Newborn" when 650 is selected in "Heights mm". If I can get this to work then I want to add different criteria to it.

 

[boblarson]

When you say "lookup" what do you mean exactly? You don't have a combo box set in the table directly do you?

 

[The Sharkster]

Yes I do. Can I not do it this way?

 

[boblarson]

You should not have lookups defined at table level. You can use combos/list boxes on FORMS to select the items (in order to store the ID numbers but display the text).

See here for more about why lookups at table level are "evil."

That is most likely why your query is not working properly.