ACCESS 97 QUERIES

[chrisfox1975]

I am looking for an answer to a MS Access Query.

I want to set the criteria for the query to be a table of values rather than a specific text field.
is ths possible?

Thanks in advance

[TTG]

Sorry, not sure what you mean. Do you want to compare a numeric field to a list of values? Do you want to compare a numeric field to a set of values held in a table?

[chrisfox1975]

Sorry I am unclear.

I have a table of errors. fields error1 error2 to error5. I want to use a query to search each error field, but the criteria for searching is a table of values. eg. table field list contains 10 error codes. E01, E02, E03 ETC. Rather than using a query for each error code, I want to know is there a way of having the query search the error fields for any of the values in the table rather than for each specific error code.

[TTG]

Sorry for the late reply...I've been out all day enjoying the sun!

In query design view....
Add the table of errors and then the table of values (I will call the table errorcodes and the code field errorcode).
Do not link them.
Select the first error field....using your example, error1
In the selection criteria, add =[errorcodes]![errorcode]
When the query is run it will show the field error1 if the value is found in the errorcodes table.

Repeat the final step for error2,3,4,5