Problem using SQL string to import data from Access table

[atf32]

Currently I am having a problem with importing data from an access table using an SQL statement via VBA. The table is a simple one, with Column 1 (called FName) and holds a list of first names. Column 2 (called LName) and holds a list of of last names. My string is as follows:

MySQL = "SELECT LName, FName" & _
" FROM tblClientNames" & _
" GROUP BY LName"
​

With the above string, I get an error message (run-time error '-2147217887(80040e21) with the message "You tried to execute a query that does not include the specified expression 'FName' as part of an aggregate function"

If I exclude the "FName" column, the data is imported. However, I only get the column of last names (LName).

I cannot find a resolution on this...Need help on this

 

[xenou]

Group By clauses are usually needed when using SQL aggregate functions (such as SUM, COUNT, MAX, MIN, AVG). The use of a group by clause is superfluous here.

Just:

MySQL = "SELECT LName, FName FROM tblClientNames;"

If you want only the unique last name, first names use DISTINCT:

MySQL = "SELECT DISTINCT LName, FName FROM tblClientNames;"

I honestly don't know if this would work but you could try (it's bad form, I think) if you really want to group the names:

MySQL = "SELECT LName, FName" & _
" FROM tblClientNames" & _
" GROUP BY LName, FName;"

 

[atf32]

Thanks, all three examples worked. Appreciate the helps.