Hi,
I know I have been asking a lot of questions but here is another. I am getting the following error:
Technical information
Error number -2147217900
Error description [Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause.
URL /qryEnquiry_list.asp
SQL query select [EnquiryID], [CustomerFK], [AssignedConsultant], [Status], [EnquiryDate], [LoanType], [LoanAmount], [Title], [FirstName], [MiddleName], [Surname], [DOB], [CurrentAddress1], [CurrentAddress2], [CurrentSuburb], [CurrentPostcode], [CurrentState], [HomePhone], [Mobile], [WorkPhone], [Fax], [Email], [Gender] From [qryEnquiry] ORDER BY [EnquiryID] DESC where [AssignedConsultant]='TJamieson'
Does not happen when there is no WHERE clause. Have searched Google, the only thing I can find is that the Order by and the Where clause are the wrong way around and I do not know how to fix.
If anyone has any ideas, I would be extremely grateful to hear them.
Thanks
Julie