Expressions in Access 97

[Erosario]

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_OL C00.TERMID) Not Like "(C*" ))
ORDER BY Mid([ondate],2,4)+"0"+Left([ondate],1), WMSPRDDTA_OLC00 .ONTIME;

[JustJim]

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_OL C00.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_OLC 00.TERMID) Not Like "(C*" ) AND (SomeFlag = True) AND (SomeDate is between #01/01/2008# and #04/04/2008#)

Is this what you wanted?

Jim