Question About Criteria

[Kipster1203]

Hey everyone,



I was wondering if it was possible to do an if statement inside the criteria?

right now I have the criteria < [Hold_Date]

but this criteria must only be applied if Not IsNull([Hold_Date])

Thanks

[Kipster1203]

Here is what I'm trying out

IIf(IsNull([Hold_Date]),"",<[Hold_Date])

It's not working of course....

My reasoning is if Hold_Date is Null, then do nothing, if it's not null, then show documents that have a due date less than hold date (I placed the statement above under the due date column) Any idea on how I can fix this?

[TheShabz]

Can you post the rest of the SQL you're working with? I get the suspicion you're trying to do something but going about it the wrong way. Is your goal to get records that have a due date less than hold date FROM the ones that have a hold date? If so, what I would do is set the criteria to
WHERE HOLD_DATE Is Not Null AND Due_Date < Hold_Date