Thread: Characters found at end of sql error-Repost in microsoft.public.access.queries

  Hi, I see two immediate issues with your sql: First of all, there is a semicolon in your statement - I think Access interprets this as an end of sql marker. Secondly, a GROUP BY clause should come after the WHERE clause. Hope this helps... Regards, anlu "acss" wrote: > My last post did not contain the sql but bottomline the i have isolated the > problem in the where section of the sql yet i cant...

  My last post did not contain the sql but bottomline the i have isolated the problem in the where section of the sql yet i cant determine what is wrong SELECT Inv.OrderDate, Customers.CompanyName, Inv.InvoiceNum, [Service Details].OrderID, Inv.OrderDate, Inv.InvDate, Inv.InvoiceNum, Customers.FROMCC, Customers.BVRACCT, Customers.RECLASSTOACCT, Customers.RECLASSTOCC, Customers.Country, [Service Details].Cost, Customers.TYPE, 1 As...