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

I'm not sure what this is trying to tell me. "Prospect" is a criteria
rather than a column.
I'm sure someone knows the solution to my kanumdrum.
Thanks in advance
 
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...
doubleQuotes and singleQuotes??

use singleQuotes because the whole is a string

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Back
Top