query for two fileds a table multiple values
Posted on 2014-12-30
I am trying to write a query which will return records in a table that
The “expire” field has a value of all dates of 2014
The “ Compcode” field has values of "220,12345,king,348,346"
I only know how to use the design grid, and listed in the grids as follows:
The first column shows the table, and a ck mark so that all fields of the table will be in the result.
In the next column of the design grid, it shows the expire filed of this table, on the criteria line >#12/31/2013# And <#1/1/2015# this works just fine by itself.
Things start going whack o when I try to further filter the query by another field.
What should be in the next column of the design grid, which specifies the “compcode” field , should I be using the “critera “ line or the “ or” line ?
Should my values separated by commas, the words “or”, the words ”and”
I am lost, Any help appreciated