Grouping by a specific field.

[Boss_Tally]

I need to know how to group certain results in a query into sections by a certain field.



I am trying to take results-
And group them by state in alphabetical order

First Name	Last Name	Address	City	Zip Code	State
Sam	Adams	121 Cary Quadrangle	Leaftown	19717	PA
Bruce	Bonner	35 Madison Drive	Newark	19312	DE
Shanise	Drummond	5 Union Station West	Darlington	83231	ID
Amy	Freitas	2841 Windswept Drive	Latana	36345	AL
Gerri	Gurbuz	15 Beach Resort Blvd.	Mountainvie	96771	HI
Adam	Hewgley	2 Cascade Summit	Cayon City	97820	OR
Homel	Hutchinson	2312 Paradise Parkway	Jamaica	19947	NY
Alma	Lee	713 Graisbury Avenue	Haddonfield	08033	NJ
Al	Monde	88 West Eighth St.	Lexington	42130	KY
Susan	Musa	721 Shamans's Way	Superstation	85220	AZ
Jack	Portillo	1585 Pastura Road	Las Cruces	88001	NM
Roberta	Posisson	8 Corwin Place	Five Points	33434	FL
Richie	Richman	6090 Gentry Road East	Halfway	65663	MO
Theodore	Ripley	789 Shady Tree Grove	Moss Point	39563	MS
Sonya	Rodd	100 White Swan Road	Fort Wayne	46040	IN
Nancy	Rohrma	291 Celestial Way	Waumpum	62920	IL
Matilda	Rose	435 Frelinghuysen Road	Leafille	08049	NJ
Steve	Settles	213 Mina Street	New Bedford	03759	MA
Quincy	Smith	2 Waterfall Way	Biminy	04020	ME
Yin	Yang	1776 Washington Way	Pierre	57492	SD

[alansidman]

Can you post an example of what you have in your table and what you would like your query results to look like. Only a sample of data is needed.