query from a Table

[Chimp8471]

i want to run a query, that goes something like this:

<b>Tblevents</b>
Daycode
line
eventcode
minorstop ------> Duration of Time
majorstops ------> Duration of Time
cip ------> Duration of Time
breackdowns ------> Duration of Time
productchanges ------> Duration of Time
maintenance ------> Duration of Time

i want to get a list of only the codes that appear with the following descriptions:

"N204"
"x117"
"D301"
"h801"
"k301"
"m10"
"N301"
"N305"
"N306"
"N307"
"N308"

what i was hoping to do was to list the above codes in a new table and then in my query say:

if the code appears in this table display the results..

can this be done...if so how please

 

[neileg]

So create your new code table and bring this into your query. Join the field in your new table with the code to the eventcode field in Tblevents with an inner join. You query will then only return records where the eventcode exists in your new table.