User to select query columns

[BJ]

Hi,

I have a detailed Query with approx 30 plus columns of data and was wanting
a way where the user would be able to select the columns they want to
return.

Is there anyway to do this in form or SQL?

BJ.

 

[Jeff Boyce]

Isn't this the Access query designer? Are you reinventing something that
already exists?

More info, please

Jeff Boyce
<Access MVP>

 

[John Spencer (MVP)]

Duane Hookom (Access MVP) has a solution that may work for you.

Customized report/query based on user input

You might want to consider the Query By Form applet at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH Query By Form'
or an earlier version at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4