Very simple IIF ?

[maw230]

I want my IIF statement to not show a record if it is False.

IIF(([value1])<>([value2]), ([value1]), *do not return record*)

can't seem to find what i should use there.

 

[FoFa]

It needs to be in your criteria.
need more information to assist further.

 

[SOS]

How about:

IIF([value1]<>[value2], [value1], "")

EDIT: And you don't need all of those parentheses...

 

[maw230]

SOS, won't that just leave the field blank? I want it to not show the entire record. here is the actual code that i have in the 'Field' portion of design view:

Price: IIf(([JDNETP]<>0.59*[JDLIST]),[JDNETP],Null)

I tried Null but it just leaves the field blank while still returning the record.

 

[FoFa]

To NOT return a record, it needs to be in your Criteria, not at a field level.

WHERE ([JDNETP]<>0.59*[JDLIST]) as an example

 

[SOS]

If you don't want it to show the entire record then you just need to put this in the criteria of value1 (no IIF needed):

<>[Value2]

 

[maw230]

i tried that but i was unable to use the sums and group by's, because blah blah is "not part of an aggregate function."

i need to use the sum function in that query.

 

[SOS]

No, you can select your field again at the end of your grid and change the GROUP BY to WHERE and then use that in the criteria.

 

[maw230]

i see what you're saying. looks to be working fine. thanks a lot everyone