Mixing
MS-Access WHERE filter syntax
0
I have a query:
PARAMETERS [Enter From Date:] Text ( 255 ), [Enter To Date:] Text ( 255 );
TRANSFORM Count([Staff Programs].ID) AS CountofProgram
SELECT [Staff Programs].program_name
FROM [Staff Programs]
WHERE ((([Staff Programs].is_noshow)=No) AND (([Staff Programs].actual_date) Between [Enter From date:] And And [Enter To Date:]))
GROUP BY [Staff Programs].program_name
PIVOT [Staff Programs].staff_name;
I need to add one thing to the WHERE clause.
I have a column in the table called "Event Name"> I would like to skip any of the rows where this value is one of: 'Phone Contact', 'Cinician Travel', 'Reporting' or 'Collateral Contact'.
I have been unable to locate the syntax for this.
sql ms-access
edited Jan 2 at 18:22
marc_s
583k13011241270
asked Jan 2 at 16:12
PinkabPinkab
103
add a comment |
0
I have a query:
PARAMETERS [Enter From Date:] Text ( 255 ), [Enter To Date:] Text ( 255 );
TRANSFORM Count([Staff Programs].ID) AS CountofProgram
SELECT [Staff Programs].program_name
FROM [Staff Programs]
WHERE ((([Staff Programs].is_noshow)=No) AND (([Staff Programs].actual_date) Between [Enter From date:] And And [Enter To Date:]))
GROUP BY [Staff Programs].program_name
PIVOT [Staff Programs].staff_name;
I need to add one thing to the WHERE clause.
I have a column in the table called "Event Name"> I would like to skip any of the rows where this value is one of: 'Phone Contact', 'Cinician Travel', 'Reporting' or 'Collateral Contact'.
I have been unable to locate the syntax for this.
sql ms-access
edited Jan 2 at 18:22
marc_s
583k13011241270
asked Jan 2 at 16:12
PinkabPinkab
103
1
Add anotherANDclause to yourWHERE?
– Robert Harvey♦
Jan 2 at 16:14
1
Also check this part:Between [Enter From date:] And And [Enter To Date:], remove oneAND
– forpas
Jan 2 at 16:33
Good to finally see a parameterized query in MS Access!
– Parfait
Jan 2 at 16:47
add a comment |
0
0
0
I have a query:
PARAMETERS [Enter From Date:] Text ( 255 ), [Enter To Date:] Text ( 255 );
TRANSFORM Count([Staff Programs].ID) AS CountofProgram
SELECT [Staff Programs].program_name
FROM [Staff Programs]
WHERE ((([Staff Programs].is_noshow)=No) AND (([Staff Programs].actual_date) Between [Enter From date:] And And [Enter To Date:]))
GROUP BY [Staff Programs].program_name
PIVOT [Staff Programs].staff_name;
I need to add one thing to the WHERE clause.
I have a column in the table called "Event Name"> I would like to skip any of the rows where this value is one of: 'Phone Contact', 'Cinician Travel', 'Reporting' or 'Collateral Contact'.
I have been unable to locate the syntax for this.
sql ms-access
edited Jan 2 at 18:22
marc_s
583k13011241270
asked Jan 2 at 16:12
PinkabPinkab
103
I have a query:
PARAMETERS [Enter From Date:] Text ( 255 ), [Enter To Date:] Text ( 255 );
TRANSFORM Count([Staff Programs].ID) AS CountofProgram
SELECT [Staff Programs].program_name
FROM [Staff Programs]
WHERE ((([Staff Programs].is_noshow)=No) AND (([Staff Programs].actual_date) Between [Enter From date:] And And [Enter To Date:]))
GROUP BY [Staff Programs].program_name
PIVOT [Staff Programs].staff_name;
I need to add one thing to the WHERE clause.
I have a column in the table called "Event Name"> I would like to skip any of the rows where this value is one of: 'Phone Contact', 'Cinician Travel', 'Reporting' or 'Collateral Contact'.
I have been unable to locate the syntax for this.
sql ms-access
sql ms-access
edited Jan 2 at 18:22
marc_s
583k13011241270
asked Jan 2 at 16:12
PinkabPinkab
103
edited Jan 2 at 18:22
marc_s
583k13011241270
asked Jan 2 at 16:12
PinkabPinkab
103
edited Jan 2 at 18:22
marc_s
583k13011241270
edited Jan 2 at 18:22
marc_s
583k13011241270
edited Jan 2 at 18:22
marc_s
583k13011241270
583k13011241270
asked Jan 2 at 16:12
PinkabPinkab
103
asked Jan 2 at 16:12
PinkabPinkab
103
asked Jan 2 at 16:12
PinkabPinkab
103
103
1
Add anotherANDclause to yourWHERE?
– Robert Harvey♦
Jan 2 at 16:14
1
Also check this part:Between [Enter From date:] And And [Enter To Date:], remove oneAND
– forpas
Jan 2 at 16:33
Good to finally see a parameterized query in MS Access!
– Parfait
Jan 2 at 16:47
add a comment |
1
Add anotherANDclause to yourWHERE?
– Robert Harvey♦
Jan 2 at 16:14
1
Also check this part:Between [Enter From date:] And And [Enter To Date:], remove oneAND
– forpas
Jan 2 at 16:33
Good to finally see a parameterized query in MS Access!
– Parfait
Jan 2 at 16:47
1
1
Add another
AND clause to your WHERE?– Robert Harvey♦
Jan 2 at 16:14
Add another
AND clause to your WHERE?– Robert Harvey♦
Jan 2 at 16:14
1
1
Also check this part:
Between [Enter From date:] And And [Enter To Date:], remove one AND– forpas
Jan 2 at 16:33
Also check this part:
Between [Enter From date:] And And [Enter To Date:], remove one AND– forpas
Jan 2 at 16:33
Good to finally see a parameterized query in MS Access!
– Parfait
Jan 2 at 16:47
Good to finally see a parameterized query in MS Access!
– Parfait
Jan 2 at 16:47
add a comment |
1 Answer
1
active
oldest
votes
2
Use NOT IN:
AND ([Event Name] NOT IN ('Phone Contact', 'Cinician Travel', 'Reporting', 'Collateral Contact'))
I think it's easy to understand, more here
answered Jan 2 at 16:15
forpasforpas
18.5k3728
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54009590%2fms-access-where-filter-syntax%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
2
Use NOT IN:
AND ([Event Name] NOT IN ('Phone Contact', 'Cinician Travel', 'Reporting', 'Collateral Contact'))
I think it's easy to understand, more here
answered Jan 2 at 16:15
forpasforpas
18.5k3728
add a comment |
2
Use NOT IN:
AND ([Event Name] NOT IN ('Phone Contact', 'Cinician Travel', 'Reporting', 'Collateral Contact'))
I think it's easy to understand, more here
answered Jan 2 at 16:15
forpasforpas
18.5k3728
add a comment |
2
2
2
Use NOT IN:
AND ([Event Name] NOT IN ('Phone Contact', 'Cinician Travel', 'Reporting', 'Collateral Contact'))
I think it's easy to understand, more here
answered Jan 2 at 16:15
forpasforpas
18.5k3728
Use NOT IN:
AND ([Event Name] NOT IN ('Phone Contact', 'Cinician Travel', 'Reporting', 'Collateral Contact'))
I think it's easy to understand, more here
answered Jan 2 at 16:15
forpasforpas
18.5k3728
edited Jan 2 at 16:22
answered Jan 2 at 16:15
forpasforpas
18.5k3728
answered Jan 2 at 16:15
forpasforpas
18.5k3728
answered Jan 2 at 16:15
forpasforpas
18.5k3728
18.5k3728
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54009590%2fms-access-where-filter-syntax%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Add another
ANDclause to yourWHERE?– Robert Harvey♦
Jan 2 at 16:14
1
Also check this part:
Between [Enter From date:] And And [Enter To Date:], remove oneAND– forpas
Jan 2 at 16:33
Good to finally see a parameterized query in MS Access!
– Parfait
Jan 2 at 16:47