If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pulling a report with multiple last names
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. |
#2
|
|||
|
|||
Pulling a report with multiple last names
"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 "crenster" wrote in message ... 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. |
#3
|
|||
|
|||
Pulling a report with multiple last names
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 On Feb 18, 3:51 pm, crenster wrote: 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. |
Thread Tools | |
Display Modes | |
|
|