Food & Drink2 mins ago
ACCESS 97 QUERIES
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
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
Answers
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 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.
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
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