Search results

Thank you for your reply. I probably did not explain the problem correctly but the fields will have data in them on the database for both Price and Date Ordered. However, the librarian may only want to search for a price range at any one time without inputting a date range or vice versa...

I have created a query so that two fields have a range in them i.e. One Field called "Price" There are two text boxes on the seach form called "price1" and "price2" The query reads Between [price1] And [price2] A second field called "Date Ordered" There are two text boxes on the search form...