optional queries fields output

[inungh]

I have a query which has 30 fields in the result set.
I would like to have them output as users choices and users can output
as many as he she wants.

I try to avoid to build SQL at run time which I know it should work
but will take some time to do it,

Are there any easy way to check check box on the form from saved query
and output fields accordingly without coding?

Your information is great appreciated,

 

[Duane Hookom]

There is a complete adhoc querying "applet" available at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=12. It allows
users to select the fields, set criteria, aggregate, etc. Results are a
couple clicks from sending to Excel or other formats.

 

[Piet Linden]

I have a query which has 30 fields in the result set.
I would like to have them output as users choices and users can output
as many as he she wants.

I try to avoid to build SQL at run time which I know it should work
but will take some time to do it,

Are there any easy way to check check box on the form from saved query
and output fields accordingly without coding?

Your information is great appreciated,

Without code? I think your only option may be to make a copy of the
query and let them check off the fields they want to see right in the
QBE grid...
otherwise, you would have to do it with code, I think... Not
impossible, but not trivial if you are not reasonably experienced in
VBA.