Hey hey,
I've been asked to create my company's database and I'm a little out of my depth when it comes to queries & reporting.
My query (well... table) has the following fields: Date Invoiced, Product, Quantity, Subtotal Price, JobCode, State
I've been able to filter the report with dates by simply using the date criteria " Between [Date from] And [Date to] "... essentially two boxes pop up asking me which dates to choose between.
However, I would also like to be able to filter by state and job code. The job code contains two entries (DM / SW) and I'd like to have the option to choose either one or both.
Furthermore, I need to be able to filter depending on which state the job was in (QLD, NSW, VIC, SA, WA, NT, ACT, TAS) or all of them. It appears that all basic query criteria is restricted to finding specific values.
The only option I know of is to create dozens of queries depending on which specific filter I would like... But that seems highly impractical and I'm sure that someone that is far more knowledgable than I could be of assistance.
Ideally, a form with drop down boxes would be preferred but if I'm limited to boxes popping up asking for parameters then that is fine 
My skills in access are rather rudimentary so if you could break it down that would be amazing!
Current SQL:
Code:
SELECT [Mock Jobs].[Date Invoiced], [Mock Jobs].Product, [Mock Jobs].State, [Mock Jobs].Quantity, [Mock Jobs].[Subtotal Price], [Mock Jobs].[Job Code]
FROM [Mock Jobs]
WHERE ((([Mock Jobs].[Date Invoiced]) Between [Date from] And [Date to]) AND (([Mock Jobs].[Job Code])="deck-max"));
Regards,
Harry.