Thanks, I'm probably not being clear, I want to run a query against a single access table, I want all rows against three values in a key field and within those rows all rows against the circa 270 rows from another number field, so for this latter field I'm guessing a dlookup table (this is the editable bit so at a later point i can change the lookup table contents to update the query) I just can't quite get my head aroud the criteria syntax,
its the expression and domain parts i don't quite get, and the criteria part of a dlookup syntax is the content of the dlookup table, , say the pertinent fields are site and stock item, of all the rows in the table, i want 3 out of 3000 sites and within those 3 sites 270 of 1500 stock items, at a later point i want to edit the 270 list so this is where i thought a seperate table containing the 270 but how to write the dlookup syntax in the criteria field of the query?
I hope this makes more sense!
thanks
Jason