Grouping Data

main-man

Registered User.
Local time
Today, 11:17
Joined
Oct 20, 2005
Messages
48
How do i group the following records

ID Surname Pack
29679 Minican 1
29679 Minican 2
27818 Oliver 1
27818 Oliver 2
27818 Oliver 3

so its will show ...

27818 Oliver
29679 Minican

... on a spreadsheet
 
create a query and select the Id and surname
click on the totals icon on the toolbar (sideways'M')

This will group all the ids' and surnames
 

Users who are viewing this thread

Back
Top Bottom