Problem In Sql Expression Field Of Crystal Report

gopal2006

Well-known member
Joined
Feb 1, 2006
Messages
63
Programming Experience
1-3
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
 
help me out

Can any one please help me out with this problem. I tried to solve this problem in many ways. So I plead any one to get solution for this problem.
 
Tried this also

Mr Macktool

I tried the way you have mentioned. Still it is giving the same error.

Any other solution?
 
Back
Top