By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Expressions in Access 97

P: 1
With the cause WHERE I can make the querie work and take out one value. But how do you make is work to take out multiple values. I tried everything and I can't get it to work.

Thank you Rick

SELECT Mid([ondate],2,4)+"0"+Left([ondate],1) AS [Date], WMSPRDDTA_OLC00.ONTIME AS [Time], WMSPRDDTA_OLC00.TERMID AS [RF Dev], WMSPRDDTA_OLC00.USERID AS [User Name] INTO tblRFUsers
FROM WMSPRDDTA_OLC00
WHERE (((WMSPRDDTA_OLC00.TERMID) Not Like "(C*" ))
ORDER BY Mid([ondate],2,4)+"0"+Left([ondate],1), WMSPRDDTA_OLC00.ONTIME;
Mar 12 '08 #1
Share this Question
Share on Google+
1 Reply


JustJim
Expert 100+
P: 407
With the cause WHERE I can make the querie work and take out one value. But how do you make is work to take out multiple values. I tried everything and I can't get it to work.

Thank you Rick

SELECT Mid([ondate],2,4)+"0"+Left([ondate],1) AS [Date], WMSPRDDTA_OLC00.ONTIME AS [Time], WMSPRDDTA_OLC00.TERMID AS [RF Dev], WMSPRDDTA_OLC00.USERID AS [User Name] INTO tblRFUsers
FROM WMSPRDDTA_OLC00
WHERE (((WMSPRDDTA_OLC00.TERMID) Not Like "(C*" ))
ORDER BY Mid([ondate],2,4)+"0"+Left([ondate],1), WMSPRDDTA_OLC00.ONTIME;
Hi Rick,
WHERE is a logical evaluation which can include multiple other logical evaluations.

eg (using pseudo-code)
WHERE ((WMSPRDDTA_OLC00.TERMID) Not Like "(C*" ) AND (SomeFlag = True) AND (SomeDate is between #01/01/2008# and #04/04/2008#)

Is this what you wanted?

Jim
Mar 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.