Microsoft Access

Question

Here is the question.........Open the Microsoft® Access file CH12 Contact Data from the data files. 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.

I am having issues just creating the query to contain all fields except home phone for those states.... please help!!

Answer 1

This is from the Access Contact database. This is the SQL format that you can past into the SQL view of an Access query.

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];

It sorts by last name and is filtered on the two states.

Book a session and I can take you through your query and how to get a corrected mail merge.