Donate SIGN UP

ACCESS 97 QUERIES

Avatar Image
chrisfox1975 | 20:49 Fri 25th Jun 2010 | Computers
3 Answers
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
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by chrisfox1975. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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?
Question Author
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.
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

1 to 3 of 3rss feed

Do you know the answer?

ACCESS 97 QUERIES

Answer Question >>