Invalid Column Name Error

[cvegas]

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.

 

[Marshall Barton]

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"));

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"