Question

Create a query to contain all fields except Home Phone for clients who live in Ohio or Illinois. Sort the records by the Last Name field. Use the mail merge feature of your word processing software to create mailing labels for these clients. The labels will be attached to advertising brochures to be sent to these clients.

Clients

Title	First Name	Last Name	Address	City	State	ZIP Code	Home Phone
Mr.	David	Morad	100 Bent Tree	Fairfield	OH	45221	[phone]
Ms.	Sue	Coates	691 Meadow Lane	Cincinnati	OH	45228	[phone]
Mr.	Alfredo	Morales	5773 Beech Road	Covington	KY	41011	[phone]
Mr.	Mike	Goldstein	321 Asbury Drive	Cincinnati	OH	45230	[phone]
Mr.	Chris	Wong	3115 Dunne Road	Alexandria	KY	41032	[phone]
Mr.	Carlos	Moretz	1128 Eighth Avenue	Lawrenceburg	IN	47025	[phone]
Mr.	Stephen	Joyner	4563 Findley Avenue	Lawrenceburg	IN	47025	[phone]
Mr.	Al	Skirvin	1005 Dayton Avenue	Dayton	KY	41201	[phone]
Ms.	Anna	Tipton	54 Dumfries Avenue	Ft. Thomas	KY	41075	[phone]
Ms.	Betty	Jung	1589 East Street	Dayton	OH	45410	[phone]
Mr.	Kwaishan	Sneed	5100 Burlington Pike	Florence	KY	41042	[phone]
Mr.	Bang Van	Phan	1831 Pleasant Run	Cincinnati	OH	45281	[phone]
Mr.	Chris	Wones	412 Terwilleger's Run	Cincinnati	OH	45227	[phone]
Mr.	Scott	Barkley	4100 North Bend	Cincinnati	OH	45251	[phone]
Ms.	Margaret	Balli	224 Grandview Drive	Newport	KY	41071	[phone]
Mr.	Don	Sujak	4050 El Paso Drive	Naperville	IL	62263	[phone]
Ms.	Linda	Hartley	2570 Foxfield	Naperville	IL	62263	[phone]
Mrs.	Dineen	Ebert	27 Main	Indianapolis	IN	46201	[phone]
Ms.	Dorothy	Wiese	28 South Water	Elgin	IL	60123	[phone]
Mrs.	Betsy	Wascher	2270 Homer	Elgin	IL	60123	[phone]
Ms.	Jenna	Ericksen	34 Emerson	Covington	KY	41011	[phone]
Mr.	Randall	Ramey	40 Hydraulic	Yorkville	IL	60560	[phone]
Mrs.	Petrina	Jackson	120 Western	Naperville	IL	62263	[phone]
Ms.	Jackie	Kaufman	505 Pennsylvania	Carbondale	IL	62901	[phone]
Ms.	Patricia	Jachowicz	302 North Lake	Cincinnati	OH	45230	[phone]
Mr.	Pietro	Lorenzini	1444 Farnsworth	Naperville	IL	62263	[phone]
Mr.	Leslie	McTighe	501 Keslinger	Indianapolis	IN	46201	[phone]
Mr.	Aaron	Vessup	2 Broadway	Alexandria	KY	41032	[phone]
Mr.	Steve	Johnson	660 Washington	Dayton	OH	45410	[phone]
Mrs.	Dorothy	Kutemeier	115 Wesley	Evanston	IL	60201	[phone]
Mrs.	Barbara	Johnson	764 Parson Street	Henderson	KY	42419	[phone]
Ms.	Rachael	Johnson	421 Capitol	Springfield	IL	62701	[phone]
Mr.	Arturo	Vasquez	309 Indian Trail	Covington	KY	41011	[phone]
Mr.	Carl	Zeigler	200 Whitfield	Cincinnati	OH	45227	[phone]
Ms.	Elena	Rodriguez	32 Washington	Elgin	IL	60123	[phone]
Mr.	Marcus	Williams	5670 Palm	Dayton	OH	45410	[phone]
Ms.	Melissa	Hefferin	2300 Johns Street	Kankakee	IL	60954	[phone]

Answer 1

SELECT Contacts.Company, Contacts.[Last Name], Contacts.[First Name], Contacts.[E-mail Address], Contacts.[Job Title], Contacts.[Business Phone], Contacts.[Mobile Phone], Contacts.[Fax Number], Contacts.Address, Contacts.City, Contacts.[State/Province], Contacts.[ZIP/Postal Code], Contacts.[Country/Region], Contacts.[Web Page], Contacts.Notes, Contacts.Attachments

FROM Contacts

WHERE (((Contacts.[State/Province])="Ohio" Or (Contacts.[State/Province])="Illinois"))

ORDER BY Contacts.[Last Name];