User to select query columns

BJ · Jun 19, 2005

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 · Jun 19, 2005

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

More info, please

Jeff Boyce
<Access MVP>

John Spencer (MVP) · Jun 19, 2005

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

User to select query columns

BJ

Jeff Boyce

John Spencer (MVP)