S
slrp
First let me state that I am fairly new to Access (2003), although I am very
familiar with Excel. That being said, I am running into difficulty with
duplicates and extra spaces/rows appearing on my report. Here is what I have:
* Four tables: Address, Family, Email & Phone
* I created a query, Address Query, that pulls most of the fields from all
four of these tables. The relationships are:
Address & Family: one-to-one;
Address & Email: one-to-many;
Address & Phone: one-to-many
The links between these tables are Last Name & First Name (which are in all
four tables).
* I created a columnar report (2 columns), Address Report, from the Address
Query
* For each field in the report, I have formatted Hide Duplicates as Yes, Can
Shrink as Yes and Can Grow as Yes. I have also said Yes to the latter two
items for the Detail section.
* Further, I have used several Text Boxes joining the fields. For example,
(a) =Trim([Last Name] & ", " & [First Name])
(b) =Trim([Number] & " " & [Phone_Notes] & " " & [Phone_Type])
where Phone_Notes is perhaps a name and Phone_Type may be "Cell"
or "Home"
Problem #1: When I have multiple listings of a phone number for a given
last name & first name, the records appear on the output, but there are two
to three rows of spaces inserted in-between. The initial portion (e.g., the
names & addresses) is properly single-spaced.
Problem #2: When I have multiple phones and e-mails, the output tends to
repeat some of the data over again. For example, there may be 3 phone
listings linked to the Last Name and First Name and there may be 2 e-mail
listings linked to the Last Name and First Name and each of the phone numbers
are showing up twice.
Any thoughts? Thanks.
familiar with Excel. That being said, I am running into difficulty with
duplicates and extra spaces/rows appearing on my report. Here is what I have:
* Four tables: Address, Family, Email & Phone
* I created a query, Address Query, that pulls most of the fields from all
four of these tables. The relationships are:
Address & Family: one-to-one;
Address & Email: one-to-many;
Address & Phone: one-to-many
The links between these tables are Last Name & First Name (which are in all
four tables).
* I created a columnar report (2 columns), Address Report, from the Address
Query
* For each field in the report, I have formatted Hide Duplicates as Yes, Can
Shrink as Yes and Can Grow as Yes. I have also said Yes to the latter two
items for the Detail section.
* Further, I have used several Text Boxes joining the fields. For example,
(a) =Trim([Last Name] & ", " & [First Name])
(b) =Trim([Number] & " " & [Phone_Notes] & " " & [Phone_Type])
where Phone_Notes is perhaps a name and Phone_Type may be "Cell"
or "Home"
Problem #1: When I have multiple listings of a phone number for a given
last name & first name, the records appear on the output, but there are two
to three rows of spaces inserted in-between. The initial portion (e.g., the
names & addresses) is properly single-spaced.
Problem #2: When I have multiple phones and e-mails, the output tends to
repeat some of the data over again. For example, there may be 3 phone
listings linked to the Last Name and First Name and there may be 2 e-mail
listings linked to the Last Name and First Name and each of the phone numbers
are showing up twice.
Any thoughts? Thanks.