Header won't print multiples

[Brenda C.]

I've got two tables that are joined which contain the data for the report I
am generating. The report page header is fine, it's the data header that's
not functioning as I need for it to. Example below...

Name
Address1
Address2
Address3
Data
Data
Data
Data
Data...

I can't get Address2 and Address3 to show up in the header I've created.
Instead, the data shows up as follows:

Name
Address1
Data
Data
Data
Address2
Data
Data
Data
Address3
Data
Data
Data

The data is repeated in full after each Address.

I have a constraint on the tables, I do not have primary keys set up because
there are multiple pieces of data for each Name in each table. There are no
one-to-one relationships between the two tables.

Thanks,
Brenda C.

 

[KARL DEWEY]

It sounds like you have Address1 and Address2 in separate records instead of
different fields of the same record.
What kind of relationship is there between the two table? What data is in
each table?

 

[Brenda C.]

You were right Karl, Thank You - I changed the table to include Address1 and
Address2, etc. in different fields of the same record. From that process I
was able to utilize the primary key in the id field.

In Table 1 I have id, name, and Address1, Address2, etc.
In Table 2 I have id, name, and data, data, data, etc.

Now the relationship between Table 1 and Table 2 is a one-to-many.

The records are showing up in the report well, but now I have spaces in
those records for which they only have an Address1, no Address2, Address3,
etc. This is a large blank space as I have up to 6 Address fields for some
users.

Any ideas there?

Now, I have a

 

[KARL DEWEY]

Yes, you can open the report in design view, click on menu VIEW - Properties.
Click on text box Address2 and set Can Grow to Yes. Then drag the size of
the box to a hairline. If there is data it will grow to accomodate the
information.

 

[Brenda C.]

Perfect - thanks again Karl!

Yes, you can open the report in design view, click on menu VIEW - Properties.
Click on text box Address2 and set Can Grow to Yes. Then drag the size of
the box to a hairline. If there is data it will grow to accomodate the
information.