Whats wrong with this code?

[shabbaranks]

Hi all,



Im trying to call an sql command with the following code but I cant quote see why its not working, I realise why its not working due to lack or brackets so I dont suppose someone could explain the brack situation based on my code please? Do you need to add so many, whats the best practices for this?

MySql = MySql & "WHERE (((TimesheetTable.[Task Date]) Between " & sStartApprovalDate & " And " & sEndApprovalDate & " AND (((TimesheetTable.sCostCode) = 'MD-LAB')) OR (((TimesheetTable.sCostCode) = 'MT-LAB')) AND (((TimesheetTable.Approved)=FALSE))"

Help is very much appreciated - thanks!

[alansidman]

Have you tried running the query from the QBE? Was it successful? If so, then copy your SQL statement fromt he QBE to your VBA code and test it.

[shabbaranks]

Thanks, I managed to get it working. The problem with my code was that I had the incorrect content in the criteria.