If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Max number of fields
I have a strange application where i need to place 389
fields on a report. Ideally the fields would come from one big table. I have tried to join eight tables together in a one to one manner, as soon as i exceed 255 fields may code fails. I there any way of creating an application where i can use 389 fields and print them on a report? |
#2
|
|||
|
|||
Max number of fields
No. Access is designed to work with relational data.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "DaveS" wrote in message ... I have a strange application where i need to place 389 fields on a report. Ideally the fields would come from one big table. I have tried to join eight tables together in a one to one manner, as soon as i exceed 255 fields may code fails. I there any way of creating an application where i can use 389 fields and print them on a report? |
#3
|
|||
|
|||
Max number of fields
The Query which is the RecordSource of your Report is also limited to 255
Fields! However, 255 Fields / Columns are much more than usually needed. In a properly designed relational database, the Tables are usually long (lots of Records) but very narrow (limited number of Fields). In fact, the widest Table I have ever used had 33 Fields. Perhaps, you should check out the Relational Database Design Theory and see if it can be used in your database. -- HTH Van T. Dinh MVP (Access) "DaveS" wrote in message ... I have a strange application where i need to place 389 fields on a report. Ideally the fields would come from one big table. I have tried to join eight tables together in a one to one manner, as soon as i exceed 255 fields may code fails. I there any way of creating an application where i can use 389 fields and print them on a report? |
#4
|
|||
|
|||
Max number of fields
Dave
You've not provided any details of what types of information would be contained in your report. Nor, as the other responders have suggested, what the relationships might be among your data elements. Having a large number of data elements in a report does not mean you need a large number of data elements in a table. -- More info, please ... Jeff Boyce Access MVP |
#5
|
|||
|
|||
Max number of fields
Thanks for your comment. I understand fully why you have
responded in the way you have. Let me re-phrase the question. What is the best way to create a report which is similar to a VB6 Data Report, ie with header self numbered pages auto sizing and footer, but which allows data to be obtained using two or more queries? I have used a Data Report but this only allows me to link to a single query and hence 255 fields. I am looking for a "report tool" which allows me to show the information in a printable format which has been taken from multiple tables using more than one query. -----Original Message----- The Query which is the RecordSource of your Report is also limited to 255 Fields! However, 255 Fields / Columns are much more than usually needed. In a properly designed relational database, the Tables are usually long (lots of Records) but very narrow (limited number of Fields). In fact, the widest Table I have ever used had 33 Fields. Perhaps, you should check out the Relational Database Design Theory and see if it can be used in your database. -- HTH Van T. Dinh MVP (Access) "DaveS" wrote in message ... I have a strange application where i need to place 389 fields on a report. Ideally the fields would come from one big table. I have tried to join eight tables together in a one to one manner, as soon as i exceed 255 fields may code fails. I there any way of creating an application where i can use 389 fields and print them on a report? . |
#6
|
|||
|
|||
Max number of fields
I haven't used Report/SubReport combination a lot but that is one avenue you
may want to look at. -- HTH Van T. Dinh MVP (Access) "DaveS" wrote in message ... Thanks for your comment. I understand fully why you have responded in the way you have. Let me re-phrase the question. What is the best way to create a report which is similar to a VB6 Data Report, ie with header self numbered pages auto sizing and footer, but which allows data to be obtained using two or more queries? I have used a Data Report but this only allows me to link to a single query and hence 255 fields. I am looking for a "report tool" which allows me to show the information in a printable format which has been taken from multiple tables using more than one query. |
#7
|
|||
|
|||
Max number of fields
Maybe you might try creating seperate queries for a block of fields. Then create sub reports from these queries. Then you might be able to utilize the subform/subreport feature in the report design mode in the main report.
|
#8
|
|||
|
|||
Max number of fields
There's an example somewhere in Technet showing how to code an unbound,
multi-row report. (Sorry, I can't remember the reference.) Maybe that would help. TC "DaveS" wrote in message ... Thanks for your comment. I understand fully why you have responded in the way you have. Let me re-phrase the question. What is the best way to create a report which is similar to a VB6 Data Report, ie with header self numbered pages auto sizing and footer, but which allows data to be obtained using two or more queries? I have used a Data Report but this only allows me to link to a single query and hence 255 fields. I am looking for a "report tool" which allows me to show the information in a printable format which has been taken from multiple tables using more than one query. -----Original Message----- The Query which is the RecordSource of your Report is also limited to 255 Fields! However, 255 Fields / Columns are much more than usually needed. In a properly designed relational database, the Tables are usually long (lots of Records) but very narrow (limited number of Fields). In fact, the widest Table I have ever used had 33 Fields. Perhaps, you should check out the Relational Database Design Theory and see if it can be used in your database. -- HTH Van T. Dinh MVP (Access) "DaveS" wrote in message ... I have a strange application where i need to place 389 fields on a report. Ideally the fields would come from one big table. I have tried to join eight tables together in a one to one manner, as soon as i exceed 255 fields may code fails. I there any way of creating an application where i can use 389 fields and print them on a report? . |
Thread Tools | |
Display Modes | |
|
|