Best way to sort out report for an individual record with lots of fields

[enquiries]

Hi there,

I'm trying to find the best way to organize a report that will have ALOT of fields for an individual record. Because it is for an individual record not a group of records (and I want it to be dynamic) I'm thinking of doing a filter & query to fill in report with necessary details. This report is going to contain ALOT of fields, even the wizard that I used based on the query said that there were too many fields, but I can't cut down.

Any suggestions please?



Thanks for any help. :-D

[ItsMe]

Subforms inside a tabcontrol

[June7]

I have the same issue for one report. Too many tables for one query and too many controls. Moving some of them to subreport got around the limits.

[enquiries]

@June7 Thanks will try creating sub-report. @ItsMe yub you're right - I'm using subforms in tab control for my main form data entry but sadly can't print it like that.

[ItsMe]

Yah, I was not paying attention to the fact you are building a report.