Hello everyone, I have a question about Access that I'm not certain there is a solution for but I thought I'd ask. I have a query which I want to include all the fields in my database so that users can select the appropriate fields/filters from a form (list box w/ multiple selections and then series of combo box filters) and then export these choices to either Word or Excel. This form works great except for one thing, some databases where I use it have too many fields to allow this. The source for this form is the query mentioned above.
Do any of you experts know any tricks (maybe using unions of multiple queries) to get around this type of limitation? Or do you have suggestions for how to better this export process? Basically I don't want to have to write a specific query for each request (because there are many) and I thought this was a good solution.