Subquery Access 2010

[Computers]

Hi,





I need some help with trying to create a subquery with SQL.


I need to add a subquery to an existing query which selects all guestID field values for guests from chicago or gary.

Here is my code:

SELECT tblGuest.GuestID, tblGuest.GuestLastName, tblGuest.GuestFirstName, tblGuest.City, tblGuest.PhoneFROM tblGuest
ORDER BY tblGuest.GuestLastName, tblGuest.GuestFirstName
(SELECT GuestID
FROM tblGuest
WHERE City="Chicago" OR "Gary");


Thanks

[alansidman]

Why a subquery? Why not set the criteria for the city field to "Chicago" or "Gary"?

[Computers]

For this, I am required to practice using a sub query instead of going into design view and changing it from there.

[burrina]

So, are you saying that the above code does not work? If you put "Chicago" Or "Gary" under the field City in your qry, it will display those results.

[Computers]

Hi,

Okay, I will privately send it to you.

Thanks again.

[Computers]

oops,

Yes, every time I try to run the code I get an error that says this.

[Computers]

Never mind I figured it out.


Thanks again,
Bob

[alansidman]

For those who may be having the same issue, it is a common courtesy in forums to provide a solution when you resolve on your own. Glad you figured it out, however.