Problem with Aggregate Function ADO SQL

Hi,

I have a spreadsheet that I populate from an Access database which I have no problem doing, except for the below query.

The SQL query works fine in Access, but returns no records when running the below code from Excel and there are no error messages. This is the first Aggregate function that I have run from Excel so it's quite possible I'm missing something, but any help would be very much appreciated!

Please Login or Register  to view this content.

Hi

I believe it's because in this ADO provider you need to use the % character to denote a wildcard so the SQL should look like this:

Please Login or Register  to view this content.

Richard