Pulling a report with multiple last names

  • Thread starter Thread starter crenster
  • Start date Start date
C

crenster

When I pull a report with multiple last names in access database base off of
my queries it will not differentiate, will only pull one of those same last
names and duplicate report for everyone with the same data of the first like
name.
How can i get the report to recognize the first names of people with the
same last name.
 
"How" depends on "what"...

Unless we have some idea of what data you are storing, in which tables, we
can only guess "how" you'd need to query the data.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
In the sorting and grouping dialogue in report design view group the
report firstly by last name, then by first name. Give the first name
group a group header and put the names in that. You might also want
to give the first name group a group footer if you need to aggregate
any data per person.

But you should also cater for the possibility of two or more people
having exactly the same first and last names (I once worked with two
such people) by giving each person a unique number, e.g. EmployeeID,
CustomerID or whatever, which can be an autonumber column in the
table, so you can add one if you don't have it already. In the report
you can then add a third group level on EmployeeID, and give that a
group header and footer rather than the first name group. Individuals
of the same names will then be differentiated.

Similarly when grouping a query do so on the unique EmployeeID (or
whatever) column, not just on the names.

Ken Sheridan
Stafford, England
 
Back
Top