SQL Error

C

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

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
 
A

Andi Mayer

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top