Equine Investor
Board Regular
- Joined
- Nov 20, 2002
- Messages
- 103
Hi guys,
I've searched everywhere for this one, so any help appreciated.
I have a form with minimum and maximum parameters for a query and if EITHER of the minimum or maximum fields or both of them are left blank, then it should return all records.
Here is my criteria:
Between [Forms]![SEARCH]![TABMin] And [Forms]![SEARCH]![TABMax]
Now what I need is if either TABMin or TABMax or both are left blank that the query returns all records!
I've found some solutions, but not incorporating the two parameters - only one.
Any gurus help please?
I've searched everywhere for this one, so any help appreciated.
I have a form with minimum and maximum parameters for a query and if EITHER of the minimum or maximum fields or both of them are left blank, then it should return all records.
Here is my criteria:
Between [Forms]![SEARCH]![TABMin] And [Forms]![SEARCH]![TABMax]
Now what I need is if either TABMin or TABMax or both are left blank that the query returns all records!
I've found some solutions, but not incorporating the two parameters - only one.
Any gurus help please?