Dynamic reports?

[b-ballstyle]

I'm trying to find a way to do dynamic reports.. What I wanna do is be able to select the field I want and then create a query based on these field and show the datasheet view.. I was thinking about using a split form, so the user could select the information he want to display and then just display it in the datasheet part of the split form.

You can see my query in the pictures and also for an example, the picture 1 would be if you selected the the field "Production Center" and picture 2 if you don't!

I cant find a way to do it.. I tried to edit the record source of the form each time you change something etc but it doesn't work. I don't want to make a query for each of the possibilities of things user could try to make a report for

 

[jdraw]

Martin Green's site has a series of Access tutorials - one of which is Dynamic Reports.
It may be useful to you.
see
http://www.fontstuff.com/access/acctut19.htm

 

[b-ballstyle]

Yes, but in that tutorial, the report is only taken from one table and the only thing he's doing is filtering. It's not what I want

 

[b-ballstyle]

What do you mean?

 

[MSAccessRookie]

What do you mean?

MS Access SQL will view the results of a Query in the same way as the it will view the results from a Table.