[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Where Clause

Posted on 2014-01-28
1
Medium Priority
?
323 Views
Last Modified: 2014-01-28
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
Comment
Question by:cansevin
1 Comment
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39815058
use an "AND" operator


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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question