musclecarlover07
Registered User.
- Local time
- Yesterday, 22:08
- Joined
- May 4, 2012
- Messages
- 236
I have a query that has a total 7 Fields.
I need it to limit data to 2 of the fields.
I have a field with an expr (Expr1: DateDiff("d",[Expr2],[Expr])
It then retuns a value of how many days are left. This works fine.
This will show all values between 20 and 44. My other field is a Status (Final) I need for this to show all statuses but "Closed" but still remain between 20 an 44. If I add Not "Closed" in the criteria line in limits to a very few results. It deletes all the blanks.
How do I get it to show all expressions Between 20 and 44 an then all statuses (encluding blank values) except Closed.
I need it to limit data to 2 of the fields.
I have a field with an expr (Expr1: DateDiff("d",[Expr2],[Expr])
It then retuns a value of how many days are left. This works fine.
This will show all values between 20 and 44. My other field is a Status (Final) I need for this to show all statuses but "Closed" but still remain between 20 an 44. If I add Not "Closed" in the criteria line in limits to a very few results. It deletes all the blanks.
How do I get it to show all expressions Between 20 and 44 an then all statuses (encluding blank values) except Closed.
