Invalid Column Name Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
cvegas said:
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"));
Click to expand...


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"
 
Back
Top