Conditionally Select Rows

[Guest]

I have a DB storing various statistics for employees (e.g., hours worked,
calls taken, average handle time), and I have a form designed to allow a user
to select which stats s/he would like to display. How would I code it so that
if the user only wanted to see, for example, hours worked and calls taken,
the query would only output those two fields? That is, I am looking to modify
the 'SELECT DISTINCTROW...' statement to only include those fields that are
selected on the form the user is interfacing with.

 

[Duane Hookom]

There is a complete "applet" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which
allows users to create their own ad-hoc reports/queries.