Querying results of previous query....completely lost

[TheMaj]

I may be complicating this but I'm trying to analyze the successful results of a previous query. It shouldn't be too hard...I thought.

I'm trying to determine what my guests are drinking with their Salmon.

I have a query that returns every check number within a given date range that has Salmon on it. This work fine.

Now I want to query the db again and get ALL the beverages on those checks. Ultimately I want to determine which alcoholic beverages are on those checks.

My main table has all the fields necessary for this task. Each row represents the ordering of every menu item throughout the day. In it's simplest form it would look like this.

CheckNumb, ItemNumb, ItemCategory, BusinessDate, StoreNumb

In essence I want "all the items on all the checks that have 'salmon' (ItemNumb: 50010) on them".

Whether this is accomplished in 1, 2 or more queries is not important. I obviously want the results but also want to learn the logic and interaction of the query(s)

I appreciate any help.....thanks

[June7]

So you need all the beverage records associated with meals that had salmon. This means each record must consider data in other records of same table as criteria.

SELECT * FROM yourtablename WHERE CheckNumb IN (SELECT CheckNumb FROM yourtablename WHERE ItemNumb=50010) AND ItemCategory="Beverage";

Assumes ItemNumb is a number field.

There are other methods but that may be the easiest. Can type the sql statement in query builder SQL View then switch to Design view to see what it looks like there.