Search results

No this is a single table query, i need an extract from the 1.5 million lines bringing just those particular results so generating a smaller more workable table I built it manually by pasting stockitem Or stockitem Or stockitem etc into the criteria rows under the stock item field but this...

So sites are a 4 digit identifier and stockitems a 6 digit code, so my current query has e.g. under site, criteria syntax of 1234 Or 567 Or 3456 but having this kind of syntax in the criteria under stock item 20 times over would be a slog to create and even more to edit so it's in the criteria...

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...

Whats the easies way to have the query criteria being the equivelent of a vlookup, i.e. pointing to an editable table of values to return other than a string of values in the criteria box itself? thanks in advance! I haven't danced with Access in over a decade so on a rapid refresher