Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Todd2006
Starting Member
18 Posts |
 Posted - 2009-02-24 : 21:25:51
|
| Hi,I have this query and I am using access databasestrselect="Select TOP " & getcodes & "* Rat_Code FROM Codes where Status_Change=' ' or IsNull (Status_Change)"it gives me an error saying Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* Rat_Code'.any idea whats going wrong |
|
|
Todd2006
Starting Member
18 Posts |
Posted - 2009-02-24 : 21:39:15
|
| Ok I fixed the problem I removed the * and it worked out |
 |
|
|
|
|
|
TOP problem