I have an Access database with tables,queries, forms etc. I would like to get some data out of a query.

This is my initial cut:

SELECT RECIPE.TITLE, INGREDNT.NAME,
ShowUnitRecs.STRING, QUANTITY.MAX_QTY
FROM RECIPE, INGREDNT, QUANTITY,
WHERE
RECIPE.RECIPE = QUANTITY.RECIPE AND
INGREDNT.INGREDIENT = QUANTITY.ITEM AND
QUANTITY.ITEM = ShowUnitRecs.ITEM AND
RECIPE.RECIPE = '000001';

Where RECIPE, INGREDNT and QUANTITY are tables and
ShowUnitRecs is a Query.

Without ShowUnitRecs, the select works fine.

Thanks

you need to add ShowUnitRecs to the FROM clause

rudy

Thanks, that worked.