paul29berks
Active Member
- Joined
- Mar 15, 2004
- Messages
- 293
I have written the statement below:
IIF([type]=*B and [startdate]>Date(), "X", "Y")
My results however return all types with a start date > todays date with X and not restricted to those like B.
Can anyone suggest something in my statement I have missed?
Thanks
IIF([type]=*B and [startdate]>Date(), "X", "Y")
My results however return all types with a start date > todays date with X and not restricted to those like B.
Can anyone suggest something in my statement I have missed?
Thanks