Reports Not Printing Similar Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have E. Wood and Elmer Wood in FirstName and LastName Fields. On Report, I
am sorting on both last name and first name. Only E. Wood prints. What am I
doing wrong?
 
Which section of the report do you expect to see unique values? What are the
exact sorting and grouping levels?
 
Table 1 = Client Household
Fields = HouseholdID, HouseholdName, FirstName, StreetAddress, Phone, etc

Table 2 = Client History
Fields = HistoryID, HouseholdID (=above field), Details, Notes

Report is based on a query that creates a new field:
Name = [FirstName] & “ †& [HouseholdName]
All other fields from Table 1 and 2 are included

Desired report layout is:
Header: Name
Section A: contact details
Section B: Client History, sorted by date

Sort and grouping order is:
HouseholdName
FirstName
StreetAddress
Name - Group Header / Footer
Date

Test Data produces correct layout for
Diane Allen
J Allen
But I have two clients named Jessie Allen, distinguished by street address,
and the report only lists one of them

Aha - I have just solved one problem and created another!
One Jessie Allen had no records entered in the history table. When I
created a record for her, the report showed both Jessie Allens.
But - how do you write the report / query to show a client name and contact
details even if no data is yet entered in the History table?
 
Double-click the join line to set the join properties to include all records
from the ClientHousehold table.

--
Duane Hookom
MS Access MVP
--

PeterK said:
Table 1 = Client Household
Fields = HouseholdID, HouseholdName, FirstName, StreetAddress, Phone, etc

Table 2 = Client History
Fields = HistoryID, HouseholdID (=above field), Details, Notes

Report is based on a query that creates a new field:
Name = [FirstName] & " " & [HouseholdName]
All other fields from Table 1 and 2 are included

Desired report layout is:
Header: Name
Section A: contact details
Section B: Client History, sorted by date

Sort and grouping order is:
HouseholdName
FirstName
StreetAddress
Name - Group Header / Footer
Date

Test Data produces correct layout for
Diane Allen
J Allen
But I have two clients named Jessie Allen, distinguished by street
address,
and the report only lists one of them

Aha - I have just solved one problem and created another!
One Jessie Allen had no records entered in the history table. When I
created a record for her, the report showed both Jessie Allens.
But - how do you write the report / query to show a client name and
contact
details even if no data is yet entered in the History table?


Duane Hookom said:
Which section of the report do you expect to see unique values? What are
the
exact sorting and grouping levels?
Click to expand...
Click to expand...
 
Works perfectly. Thanks.

Duane Hookom said:
Double-click the join line to set the join properties to include all records
from the ClientHousehold table.

--
Duane Hookom
MS Access MVP
--

PeterK said:
Table 1 = Client Household
Fields = HouseholdID, HouseholdName, FirstName, StreetAddress, Phone, etc

Table 2 = Client History
Fields = HistoryID, HouseholdID (=above field), Details, Notes

Report is based on a query that creates a new field:
Name = [FirstName] & " " & [HouseholdName]
All other fields from Table 1 and 2 are included

Desired report layout is:
Header: Name
Section A: contact details
Section B: Client History, sorted by date

Sort and grouping order is:
HouseholdName
FirstName
StreetAddress
Name - Group Header / Footer
Date

Test Data produces correct layout for
Diane Allen
J Allen
But I have two clients named Jessie Allen, distinguished by street
address,
and the report only lists one of them

Aha - I have just solved one problem and created another!
One Jessie Allen had no records entered in the history table. When I
created a record for her, the report showed both Jessie Allens.
But - how do you write the report / query to show a client name and
contact
details even if no data is yet entered in the History table?


Duane Hookom said:
Which section of the report do you expect to see unique values? What are
the
exact sorting and grouping levels?

--
Duane Hookom
MS Access MVP
--

I have exactly the same problem, so if anyone can help me out...

:

I have E. Wood and Elmer Wood in FirstName and LastName Fields. On
Report, I
am sorting on both last name and first name. Only E. Wood prints.
What
am I
doing wrong?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top