GROUP BY clause not working

I'm using PHP 5 to make an ODBC connection to an MS Access database
using PEAR and I'm getting DB Error: Syntax Error when using the GROUP
BY clause. Here's my query:
SELECT * FROM HardwareInstallationsSummary WHERE LocationID = $loc_ID
GROUP BY EquipmentTypeID

Just for kicks, I changed the GROUP BY to ORDER BY. The query works, and
the items are sorted as expected, but this is not what I want. Is there
a bug in here somewhere?
TIA
.

Relevant Pages

  • Re: Please help ~ Syntax Error
    ... If this is not for a query, then you will need to change it to use ... The only time the error stops, see below, but then the report doesn't ... So perhaps I should try another approach, maybe my unbound form wasn't ... Syntax error in query expression '(Between ...
    (microsoft.public.access.formscoding)
  • Re: Calculating totals on a Crosstab Query
    ... you are getting closer qrysheds and qryTotal works ... syntax error in query Expression Count(IIf((Is ... FROM QDailyWheplingReport2 ...
    (microsoft.public.access.reports)
  • Re: Duplicate records ... sort of
    ... the query has come back with a syntax error ... FROM tblRegions as R INNER JOIN tblContacts as C ... FROM tblRegions INNER JOIN tblContacts ON tblRegions.RegionID = ...
    (microsoft.public.access.queries)
  • Re: Can I create a query (or any nifty easy way) to do this?
    ... I get is a syntax error for your example. ... The update query though still doesn't work at all. ... entry to Titles - that gives ... >>Basically the Furniture Table is a list of all possible ...
    (microsoft.public.access.queries)
  • Re: Combo box troubles
    ... I did use the query bldr ... under "Record Source" The form works fine. ... The syntax error come up in the combo box wizard after ...
    (microsoft.public.access.formscoding)