Cannot join on Memo, OLE, or Hyperlink Object

I have a basic table in an Access database. In that table, I have a 10-digit numeric field that is stored as Long Text (leading zeros are significant). I extracted the unique values from that field in the table, and created a new table/field with the same Long Text data type. When I try to …

Read more

“You tried to execute a query that does not include the specified aggregate function”

The error is because fName is included in the SELECT list, but is not included in a GROUP BY clause and is not part of an aggregate function (Count(), Min(), Max(), Sum(), etc.) You can fix that problem by including fName in a GROUP BY. But then you will face the same issue with surname. So put both in the GROUP BY: Note I used Count(*) where you wanted SUM(orders.quantity). However, orders isn’t included …

Read more