Criteria in Query

[Karen]

I have set criteria in a query to pull 9 specific names (no matter how many
times they are listed) from a field in a table. I also have a date criteria
to choose those records only from 2008. (1/1/08-now)
My problem is my query will pull all records containing those names but also
from past years.
If I delete the names from the RMID field cell then my date expression will
work.
What can I do? TIA

 

[Jeff Boyce]

Karen

I'm not sure, but it sounds like you want the rows that satisfy both
conditions (one of these 9 names, Year([YourDate])=2008).

In a query design view, you need both conditions on the same row. If you
use two rows, one for each condition, you are telling Access to find rows
that satisfy one or the other condition.

Good Luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Karen]

That worked!!! Thank you !!
--
Karen

Karen

I'm not sure, but it sounds like you want the rows that satisfy both
conditions (one of these 9 names, Year([YourDate])=2008).

In a query design view, you need both conditions on the same row. If you
use two rows, one for each condition, you are telling Access to find rows
that satisfy one or the other condition.

Good Luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have set criteria in a query to pull 9 specific names (no matter how many
times they are listed) from a field in a table. I also have a date
criteria
to choose those records only from 2008. (1/1/08-now)
My problem is my query will pull all records containing those names but
also
from past years.
If I delete the names from the RMID field cell then my date expression
will
work.
What can I do? TIA