How to get by maximum number of fields in query?

[Patience]

Hi,

I would like to make a query with many fields from many tables. The query provides data for a report.

A query can "only" contain 255 fields (or something like that). The same limitation applies to tables, forms, reports etc.

Is it however possible to make a report, based on one or more queries, where the number of fields is higher than 255?

The generation of the report is initiated from a form. The data in the report is determined by the user ticking checkboxes. I know that I can just make two or more queries/reports, but I would like to have all the data in one report so that the user does not have to switch between different reports.

Thank you very much in advance!

[RuralGuy]

I doubt I can help but I would find a report with ~255 different variables just a little difficult to grasp.

[Patience]

Yeah, I guess you are right. I will find a way around it.

Thanks for replying.