multiple reports from a query

[supernova]

Hi everyone
I am an intermediate access user and don't know much about vba or sql. I have an employee table and I want to make a form for my end user who knows nothing about access so he/she can generate multiple reports from that form by choosing different fields of the same table using check boxes. For example, the boss asks the user to generate a first name and last name list of all employees today. Tomorrow, he wants first name, last name and their employment date etc. How to make a query which can do this kind of thing? I mean having a form which has all table fields and the user can click on the check boxes necessary and then the report only shows selected check boxes.

Thanks in advance

 

[Minty]

Give him a tool to report on ALL the fields that are relevant from that table and export them to excel, he can then filter them out as required.
Rinse and repeat for as many tables / queries as possible, otherwise he'll be coming back to you every day for ever...

 

[supernova]

Give him a tool to report on ALL the fields that are relevant from that table and export them to excel, he can then filter them out as required.
Rinse and repeat for as many tables / queries as possible, otherwise he'll be coming back to you every day for ever...

I know how to export to excel but I don't want the user to export the whole table to excel, only selected fields. Can I use the "show" checkbox in query design view in my form? If I can uncheck the "show" checkbox somehow in my form, I suppose the report will not export those fields to the excel file anymore.

 

[Minty]

You can create a form that will list queries that can be used as report sources.
Normally you would create the query to restrict records to a subset of the available records and fields, and probably restricted to a period of dates.
You then simply create a set of suitable queries for the reports required.

This is a very basic sample http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=58886&d=1434367749 that you can look at and see the principle.