Query field select

  • Thread starter Secret Squirrel
  • Start date
S

Secret Squirrel

I have a query that I use to run one of my reports. What I want to be able to
do is select which fields I want printed on my report. If I was to create a
form with checkboxes for each of my fields could I use that method to select
which fields I wanted on my report? The user would then check which fields
they want from the form and then click the command button to run the report
with those chosen fields. Would this be possible? Also, I would want the
users to select which field the report would be sorted by. What's the easiest
approach to this?
 
K

KARL DEWEY

Try this on a couple of fields --
Use calculated field with IIF statement to output NULL if checkbox not
checked.
In report set the Can Shrink to Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too Many Fields Defined Error 1
Table headers in a list box (Custom Report) 3
Create report from form through vba 1
How to create a report based on used selected query 4
Iterative Query 1
Using a Parameter Query in a Report? 2
Changing field names 2
Query design 0

Top