Hi
I have a query in SQL Expressin Field of Crystal Report. Whenever I try to Create a new SQL expression field I get the error "ODBC error:[Microsoft][odbc Microsoft Access Driver] Syntax error,in query expression 'select TABLE.'TABLE_ID'. After cicking ok anohter messagebox shows error "error in compiling SQL expression: Syntax error foud here My Query is like below
select Customer.`Customer ID` from customer. I tried this query in other ways also like : select customer.customreId from customer. Even Tried with enlosing the query expression in quotes,parenthesis. But not successful. Can any one please guide me regarding this? How to write the SQL syntax here in proper way? Thanks for help in advance
I have a query in SQL Expressin Field of Crystal Report. Whenever I try to Create a new SQL expression field I get the error "ODBC error:[Microsoft][odbc Microsoft Access Driver] Syntax error,in query expression 'select TABLE.'TABLE_ID'. After cicking ok anohter messagebox shows error "error in compiling SQL expression: Syntax error foud here My Query is like below
select Customer.`Customer ID` from customer. I tried this query in other ways also like : select customer.customreId from customer. Even Tried with enlosing the query expression in quotes,parenthesis. But not successful. Can any one please guide me regarding this? How to write the SQL syntax here in proper way? Thanks for help in advance