Grouping

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

Guest

I have a report based on a query. The query result is perfect and displays the correct information for each record. In some cases there are identical surnames, and these are correctly shown with their relevant information. My problem is with the report. I have done something wrong with the grouping, because the report is combining the information for like names and showing it as one record. Help!! Thanks. Tris
 
Are you sorting and grouping on Surname? Are the text boxes located in the
detail section?

--
Duane Hookom
MS Access MVP
--

Trish said:
I have a report based on a query. The query result is perfect and
Click to expand...
displays the correct information for each record. In some cases there are
identical surnames, and these are correctly shown with their relevant
information. My problem is with the report. I have done something wrong
with the grouping, because the report is combining the information for like
names and showing it as one record. Help!! Thanks. Trish
 
Are you sure that you want to group by Surname when several individuals may
have the same surname? If you can't resolve your issue, paste few records
into a reply as well as how they currently display in the report (including
sections) and then how you would like them to appear.
 
Thanks Duane. The query brings together information from some tables and related tables

Clients_ID Client Surname Client Firstname Permanent Temporary Casual Full Time Part Time Nightshift Transport Studying Current Skills Current Licences/Certificate
93 Clarke Peggy Yes No No No Yes No No Medical Reception
93 Clarke Peggy Yes No No No Yes No No Medical Reception
113 Clarke Gordon Yes Yes Yes Yes Yes No No
113 Clarke Gordon Yes Yes Yes Yes Yes No No
93 Clarke Peggy Yes No No No Yes No No Medical Reception
113 Clarke Gordon Yes Yes Yes Yes Yes No No
15 Dodd Jean Yes Yes Yes Yes Yes No No
15 Dodd Jean Yes Yes Yes Yes Yes No No
85 Dodd Sean Yes No No Yes No No No Forklift Operator Forklift Operato
15 Dodd Jean Yes Yes Yes Yes Yes No No
85 Dodd Sean Yes No No Yes No No No Distribution Managemen
107 Jackson Sharon Yes No No No Yes Yes No
107 Jackson Sharon Yes No No No Yes Yes No
126 Masters Alison Yes Yes Yes Yes Yes No No Certificate IV Workplace Assessment & Training Cert IV Workplace Assessment & Trainin
99 Masters Michael Yes No No No Yes No No
99 Masters Michael Yes No No No Yes No No
79 Patel heena Yes Yes Yes Yes Yes No No Certificate III Children's Services
68 Patel ammed Yes Yes Yes Yes Yes No No
97 Reid Sharon Yes Yes Yes Yes Yes Yes No
24 Stone Grace Yes No No No Yes No No
The report design is as follows

The client surname is in the Client Surname Header, along with all the Yes/No check boxes. The detail section contains the Position Sought, Current Skills and Current licences

As you can see from the query result, there are many instances where there are two people of the same surname, eg Masters, Dodd, Patel. Yet in the report result, all the duplicate names appear only once, and the relevant information pertaining to these people combined into one record. I don't know how to paste my report in so that you can see it

I would be EXTREMELY grateful for ANY assistance you can give me

Thanks Duane and anyone else who can help
Tris
 
Sortby [Client Surname], [Client FirstName], [Client_ID]
Place the group header on the Client_ID field.

--
Duane Hookom
MS Access MVP


Trish said:
Thanks Duane. The query brings together information from some tables and related tables.

Clients_ID Client Surname Client Firstname Permanent Temporary Casual Full
Click to expand...
Time Part Time Nightshift Transport Studying Current Skills Current
Licences/Certificates
93 Clarke Peggy Yes No No No Yes No No Medical Reception
93 Clarke Peggy Yes No No No Yes No No Medical Reception
113 Clarke Gordon Yes Yes Yes Yes Yes No No
113 Clarke Gordon Yes Yes Yes Yes Yes No No
93 Clarke Peggy Yes No No No Yes No No Medical Reception
113 Clarke Gordon Yes Yes Yes Yes Yes No No
15 Dodd Jean Yes Yes Yes Yes Yes No No
15 Dodd Jean Yes Yes Yes Yes Yes No No
85 Dodd Sean Yes No No Yes No No No Forklift Operator Forklift Operator
15 Dodd Jean Yes Yes Yes Yes Yes No No
85 Dodd Sean Yes No No Yes No No No Distribution Management
107 Jackson Sharon Yes No No No Yes Yes No
107 Jackson Sharon Yes No No No Yes Yes No
126 Masters Alison Yes Yes Yes Yes Yes No No Certificate IV Workplace
Click to expand...
Assessment & Training Cert IV Workplace Assessment & Training
99 Masters Michael Yes No No No Yes No No
99 Masters Michael Yes No No No Yes No No
79 Patel heena Yes Yes Yes Yes Yes No No Certificate III Children's Services
68 Patel ammed Yes Yes Yes Yes Yes No No
97 Reid Sharon Yes Yes Yes Yes Yes Yes No
24 Stone Grace Yes No No No Yes No No
The report design is as follows:

The client surname is in the Client Surname Header, along with all the
Click to expand...
Yes/No check boxes. The detail section contains the Position Sought,
Current Skills and Current licences.
As you can see from the query result, there are many instances where there
Click to expand...
are two people of the same surname, eg Masters, Dodd, Patel. Yet in the
report result, all the duplicate names appear only once, and the relevant
information pertaining to these people combined into one record. I don't
know how to paste my report in so that you can see it.
 
Back
Top