Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Iif statement driving me insane

Status
Not open for further replies.
biot023

biot023

Programmer
Nov 8, 2001
403
0
0
GB
Can anybody see anything blatantly wrong with this?

Size: IIf([Pricing].[size]="A0" Or [Pricing].[size]="A1" Or [Pricing].[size]="A2",100,0)

It's supposed to put 100 in a field if a size is A0, A1, or A2, and 0 for anything else.
The trouble is, whilst it seems to most of the time, I have tests with fixed data that it doesn't pick up on.

Any help gratefully appreciated.

Douglas If it don't make you laugh, it ain't true.
 
Sort by date Sort by votes
Have you tried using "Like"?

Size: IIf([Pricing].[size] Like "A0" Or [Pricing].[size] Like "A1" Or [Pricing].[size]Like "A2",100,0)
 
Upvote 0 Downvote
If this is in a query grid replace commas (,) with semicolons (;)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
139
Swi
Swi
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
78
serino
serino
cimoli
  • Locked
  • Question
Access Query IIF statement with multiple conditions 3
Replies
6
Views
143
cimoli
cimoli
eerich
  • Locked
  • Question
IIF Help on complex query
Replies
5
Views
80
Andrzejek
Andrzejek
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
176
combo
combo

Part and Inventory Search

Sponsor

Back
Top