Package dimensions query

[aflamin24]

Hi I have a table with a bunch of packages. Each record is unique. I have 3 fields: height, length and width that I'd like to see if each package meets the criteria for. My criteria is that each package must be no larger than the dimensions of 7*16*16. The order of the dimensions do not matter, so if height of one package is 7, or less, then the other two fields can be up to 16 each. If the length is 7, or less, then the other two fields can be up to 16....im guessing you get the picture now. I have no idea how to write this criteria in terms that access will understand.



If anyone can help that would be great. Hopefully I tagged this thread right, but I was just guessing.

Thanks,
Anthony

[June7]

So at least one side must be <=7? Can't be 13x13x13?

Try:
MeetSpec: IIf([Height]<=16 And [Length]<=16 And [Width]<=16 And ([Height]<=7 Or [Length]<=7 Or [Width]<=7), True, False)

[aflamin24]

Thanks, this works perfectly. I guess I need to learn more about IIF() and its syntax....I appreciate the help!

[June7]

Syntax not really complicated.

An IIf() function basic structure:
IIf(condition, result if true, result if false)

Nested IIf:
IIf(condition, result if true, IIf(another condition, result if true, result if false))

Example of an IIf with multiple OR/AND conditions:
IIf((condition1 AND (condition2 OR condition3)) OR condition4, result if true, result if false)

Parenthesis can be critical, especially when mixing with OR operator.