Invalid Column Name Error

Invalid Column Name Error

Post by Y3ZlZ2F » Thu, 09 Dec 2004 06:19:03

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.

Invalid Column Name Error

Post by Marshall B » Thu, 09 Dec 2004 08:42:38

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"

MVP [MS Access]