I have this propblem when i use the following code it works fine

sSQL = "SELECT * from member order by lastname;"
rsMember.Open sSQL, cnDBConn, adOpenDynamic

but if i want to display a few fields thus i changed the above code with

sSQL = "SELECT lastname. firstname from member order by lastname;"
rsMember.Open sSQL, cnDBConn, adOpenDynamic

I got this error.

Err_Number: 3265
Err_Description: Item cannot be found in the collection corresponding
to the requested named or ordinal
Err_Source: ADODB.Fields

Plese Help!
Thanks

change the period after lastname to a comma