Advertisement

11.07.2007 at 10:55AM PST, ID: 22945544
[x]
Attachment Details

Access SQL Query Help

Asked by DanielT in Microsoft Access Database, SQL Query Syntax

Tags: access, sql, query, date

I have this little snippet that is giving me grief...

SELECT Subject, Status, DateCompleted, Categories FROM tblOL_Tasks
WHERE (((DateCompleted)>#9/1/2007#) AND ((Categories)="_N-UACit")) OR (status)<>"completed" AND ((Categories)="_N-UACit");

Intent...
Simply - I need to show all items that have a completed date > 9/1/2007 for a specific assigned category OR any items that have not been completed for the same category. Either criteria works on its own but when together the date filter just does not work. Any idea as to why? I need to be able to filter both parameters within this query.
Start Free Trial
[+][-]11.07.2007 at 11:04AM PST, ID: 20235127

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.07.2007 at 11:04AM PST, ID: 20235137

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.07.2007 at 11:12AM PST, ID: 20235192

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.07.2007 at 11:31AM PST, ID: 20235374

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, SQL Query Syntax
Tags: access, sql, query, date
Sign Up Now!
Solution Provided By: RDWaibel
Participating Experts: 3
Solution Grade: A
 
 
[+][-]11.07.2007 at 11:57AM PST, ID: 20235664

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.07.2007 at 12:09PM PST, ID: 20235795

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.07.2007 at 01:12PM PST, ID: 20236430

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.07.2007 at 01:43PM PST, ID: 20236741

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906