Developer Forum

I get an invalid column name "Prospect" when I attempt to bind my grid with
this syntax. .

SELECT tblAccounts.*, tblAccounts.AccountType
FROM tblAccounts
WHERE (((tblAccounts.AccountType)="Prospect"));


Thanks in advance.

Since the * ,eans all fields, you have the AccountType in
the field list twice.

Just use this:

SELECT tblAccounts.*
FROM tblAccounts
WHERE tblAccounts.AccountType="Prospect"

--
Marsh
MVP [MS Access]