A
andy.s
Finding it hard to get my head round this so help needed!
I have a query based on form fields. There is date range field (always
selected) and 2 other optional criteria needing 4 WHERE/OR statements
to get the required results.
I want to add another optional criteria field which i think will leave
me with 11 WHERE/OR statements and a big headache!
Is there a simple way around this?
I have a query based on form fields. There is date range field (always
selected) and 2 other optional criteria needing 4 WHERE/OR statements
to get the required results.
I want to add another optional criteria field which i think will leave
me with 11 WHERE/OR statements and a big headache!
Is there a simple way around this?