Parameters gathered from a form with excluded items

[trixxnixon]

i need to gather information from a form to plug into a query,

([Forms]![frm_Reporting].[type])

but i need the query to exclude one item that is an option on the form housing the parameters, unless that item is directly selected as an option... ie if the field is left blank, the report will generate pulling records baased on all but that one option. it will however generate the report if that option is directly selected.

any idea how to pull that off in access 97?

Thank you!

[NeoPa]

I'm struggling to understand the explanation Trixx. Any chance you could include some real-world data in your explanation?

[trixxnixon]

you know i did a really bad job of explaining that. but it was much easier to just build a seperate report. thank you tho. =)

[NeoPa]

Well, if you're happy then I must be :D