SteveHumby
Posts: 20
|
Posted: 10/30/2006, 7:17 AM |
|
Hi
I have a search page which displays the results in a Grid on a separate page.
The problem i have is that one of the fields contains a number, and another contains a date.
What i would like to do is have a listbox which contains a list of values such as:
1: Less Than
2: Greater Than
So if the user enters a number in the number field, if nothing is selected in the list box, the query searches for the exact value in the number field. If the listbox contains a value (such as 1 for =< or 2 for =>), then the query searches for a greater or less than result.
The same applies with the date field, this time using Before or After.
Any help would be appreciated.
Thanks
|
|
|
|