Report limitation and subreports

Hi. I'm working with Access 97 ( I know. Its old and outdated). I have two
questions.
1: I'm trying to make a report showing about seventy fields from two tables.
Ten fields from the first table and sixty from the second. There seems to be
a limitation in Access on the number of fields in one report. How do I make a
report showing seventy fields?
2: I have tried using subreports, but it doesn't work. I tried the wizard
using the suggestion: "Show Table2 for each record in Table1 using Tag".
Where Tag is the primary key in both tables and the tables are relatied in
one-to-one-relationship. The subrepoprt always ends up beeing blank. I've
tried many ways. What am I missing?

I'm old and outdated, too, but I can still get around

It would appear on the surface you have too many fields in your report;
however, this can be deceiving. It has more to do with sorting and grouping.
I had a similar problem, and found that removing one grouping resolved the
problem.
--
Dave Hargis, Microsoft Access MVP


"Are A M" wrote:

Hi. I'm working with Access 97 ( I know. Its old and outdated). I have two
questions.
1: I'm trying to make a report showing about seventy fields from two tables.
Ten fields from the first table and sixty from the second. There seems to be
a limitation in Access on the number of fields in one report. How do I make a
report showing seventy fields?
2: I have tried using subreports, but it doesn't work. I tried the wizard
using the suggestion: "Show Table2 for each record in Table1 using Tag".
Where Tag is the primary key in both tables and the tables are relatied in
one-to-one-relationship. The subrepoprt always ends up beeing blank. I've
tried many ways. What am I missing?