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?
Code:
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!