• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

Where Clause

I am currently using a where clause that is:

WHERE (((qryMemoswithDate.DateCalled) Between #1/1/2014# And #12/31/2014#))

I want to add the following to it... how would I combine so it is a "compound" where?

[RecordedMessage]=[qryWhosComputer]![Last])
0
cansevin
Asked:
cansevin
1 Solution
 
Rey Obrero (Capricorn1)Commented:
use an "AND" operator


WHERE (((qryMemoswithDate.DateCalled) Between #1/1/2014# And #12/31/2014#) AND [RecordedMessage]=[qryWhosComputer]![Last])
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now