Querying text in a 'numeric' combo box

[fraser_lindsay]

I have a number of categories on which I assign a relative risk - at the moment H, M and L. Previously I had these set as a value selection combo and they were as 'text'.

More recently I have changed this now to a lookup and put the risk rating into a separate table. As a consequence the field is now 'numeric' but displays text from my combo.

When running a linked query I now get an error message instead of the required response.

My query should report back a 'Yes' if the queried cell contains an 'H' or 'M'.

Audiometry: IIf([tblRiskProfile]![Noise]="H" Or [tblRiskProfile]![Noise]="M","Yes","No")

However, this obviosuly doesn't work now because of the cell properties being numeric. How do I ammend the string above to run the same query?

 

[neileg]

Just substitiute the equivalent numeric values in the Iif statement. The logic stays the same.