Nick

>Is there a way that a user can create their own query through an interface and then generate a report from that query?

Look at Stonefield Query and Stonefield Reports. Your job will be much simpler, as those tools already have what you need. www.stonefield.com