Access ADO - SQL query (3 cell values)

Hi Guys,

I am trying to run a SQL query based on 3 cell values within the workbook. The 3 variables are >= "StartDate", <="EndDate" and "Employee"

Im able to successfully query the StartDate & EndDate but when adding Employee i'm getting a "Syntax error (missing operator) in query expression

Below is the SQL code used

Please Login or Register  to view this content.

Any help would be much appreciated

Thanks, Dan

Your missing the "="

Please Login or Register  to view this content.

Hi Mike

Thanks for your reply - when I use your code i'm now given the following error

"Run-time error'-2147217900 (80040e14)':
Syntax error in query expression '(((Employee ='Dan' AND EntryDate)>=11/07/2012 AND (EntryDate <=28/07/2012));'.

I have confirmed that there is data within the DB that meets this criteria

Any ideas are much appreciated

thanks

Sorry I just done it off the top of my head. This should work

Please Login or Register  to view this content.

Hi Mike

Just tried the above and still seem to be getting the Syntax error

Thanks

Sorry again but this should work

Please Login or Register  to view this content.

Hi Mike

Excellent, worked a treat! I just took out the "CDate" function as the dates are stored as a number in the worksheet

Thanks alot for your support

Dan

If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix".
Change to "Solved"
Click Save