How many fields?????

[ebasta]

Hi ,

how many fields may I put in a query?Because I need to make a report with moe then 150 fields (bolnged to 15 differents tables)!

Thank you very very much!

 

[Mile-O]

Are you sure your tables are normalised?

 

[ebasta]

100%

I need so many tables because they're 1->infinite with the main one!this the best you can imagine!!!imagine that I have even 25 forms connected to the tables!It's a mess, but I need them!

 

[Len Boorman]

If you are certain that your tables are normalised then I think that I would suggest that you use sub reports each supported by a query to construct your overall report.

Reasons
Basically because I think it would be easier to manage the report construction and design.

Probably the data does decompose into logical groups.

You can set the Can Grow/ Can Shrink on the sub report so that if a section does not have any data then you will not have a lot of white space on your report.



len B

 

[ebasta]

Thank you!!!!