I have made a form with 4 fields on it. I want the user to enter data into these fields, and then a query should be run to find this data in the relevant table.
This would be a very simple query to create, except i dont want it to just find records that are found by looking at data entered into all four fields on the form. I want the user to enter data into whichever fields he wants to seach, meaning that the query should only look at the fields on the form were data is entered and find this data in the table. So for example, as the user i may only enter data into the second and fourth fields - the query should only search for these fields in the table.
Can anyone explain how such a query can be created for this situation?
This would be a very simple query to create, except i dont want it to just find records that are found by looking at data entered into all four fields on the form. I want the user to enter data into whichever fields he wants to seach, meaning that the query should only look at the fields on the form were data is entered and find this data in the table. So for example, as the user i may only enter data into the second and fourth fields - the query should only search for these fields in the table.
Can anyone explain how such a query can be created for this situation?
