i have a query with all my invoice data in and i am now looking to filter that query by several methods such as by contract, betweeen dates ect but i am un sure of the best way to proceed, would it be to have another query to filter by date and another by query which then in turn opens the final query or is there a way of having all these criterias on 1 query?


thanks

w0od0o

Filter on a form is probably better. You can toggle on and of diffrent filter as you see fit.

JR

thats fine but doesnt the form have to have a query behind it with the relevant criterias on it?

got it thanks :)