stevefishwickuk
Registered User.
- Local time
- Today, 18:08
- Joined
- Apr 6, 2006
- Messages
- 14
Hi,
I am trying to get an iff statement to work with a dlookup. So the criteria which are held in a static table can be adjusted by the user without having to amend the query.
Unfortunately it does not work and produces the TRUE result only and ignores the FALSE criteria.
[fld_scorecard_criteria] equals >=3 so I cannot put a = in before. If I add speech marks in it changes the number to a string and errors.
Many thanks for your help, in advance.
I am trying to get an iff statement to work with a dlookup. So the criteria which are held in a static table can be adjusted by the user without having to amend the query.
Unfortunately it does not work and produces the TRUE result only and ignores the FALSE criteria.
Code:
IIf([CountOfname] & DLookUp("[fld_scorecard_criteria]","stc_PSL_scorecard","[fld_band_id] = 1"),8,0)[fld_scorecard_criteria] equals >=3 so I cannot put a = in before. If I add speech marks in it changes the number to a string and errors.
Many thanks for your help, in advance.
