I've changed my recordset to include the field names but I still get the error:
WARNING!! Error in Advanced Search extension
----------------------------------- SELECT AdID, ItemName, OrderDate, ItemLocation, ItemZipCode, ItemPrice, CategoryName, SubCategoryName FROM qryGetAds ORDER BY OrderDate DESC
----------------------------------- SELECT AdID, ItemName, OrderDate, ItemLocation, ItemZipCode, ItemPrice, CategoryName, SubCategoryName FROM qryGetAds HAVING (ItemName like '%saddle%') ORDER BY OrderDate DESC
----------------------------------- [Microsoft][ODBC Microsoft Access Driver] HAVING clause (ItemName ALike '%saddle%') without grouping or aggregation. |
|
|