SQL Error?

[brucemc777]

Good Afternoon Everyone!

Can anyone tell me what i am doing wrong with the following?

    sSQL = "SELECT ContactBilling, EmailBilling, BankAccount, FROM qryCustomerEmail"
    
    Set db = CurrentDb
    Set rs = db.OpenRecordset(sSQL, dbOpenSnapshot)

As i am getting the following error:

Since i am learning about recordsets right now due to necessity, i am using without fully understanding, and unfortunately the same goes with SQL - some knowledge, more than i have about nuclear reactors, but less than i have about a stapler. I went to the length of copying the spelling from the source items into the SQL text to eliminate "fat finger issues" in spellink.

Many thanks for your kind consideration!!!
-Bruce

 

[plog]

Comma after BankAccount