Limits on the # of fields a record source can provide a report

[PZStraube]

Rookie post.

I am under the impression that when creating a report in Access 2003,
you can use only one "record source" (query or table) to provide data
(acknowledging that several tables or queries may may be used to create
the final record source) and that 255 data fields are the maximum you
can access. Is that right?

I have a detailed spreadsheet in Excel that I would like to move to
Access (which is where the raw data comes from anyway). It has 20 rows
of roughly 120 datafields - thus, giving a total number of roughly 2,400
datafields. This is no problem in Excel, of course, but I think I'm
beyond the limit in Access 2003.

Thanks for any comments you may have!

 

[Duane Hookom]

Think database.
1) I would question why you need 120 data fields.
This seems un-normalized but you haven't provided
any information on your structure
2) 120 data fields should create 120 controls in your
detail section of your report, not 2400.

Take a look at any report in the Northwind. Counting the number of controls
on a report is not the same as printing the report and then counting the
number of displayed items on the report.