I've been looking around here and there's a couple threads I think might be trying something similar. What I want to do is create a form that gives the user the ability to choose thier search critea for any element pertaining to a work order, like say they want a work order from company a between 2 dates. Then using this same form beable choose different criteria to make up a report.

The way I see it is a check list of all the elements I want to search by that can be interrelated. What I don't want to do is create 20 different reports and based on the critea choose that report. So how abouts, if its possible, can a report be created by what a user has chosen in their crieteria from the form.

Any help on this would be great.

You have to build the sql statement for the report at runtime. Search the forum for dynamic sql. I know I have post several examples of what you are reffering too.