SQL SELECT problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
I have a form with a chart that uses a "SELECT DISTINCT TOP" sql command as
rowsource.
The problem is that when i started to use this sql command, when i load the
form i have a message telling me that there's an error on the OLE SERVER.

Can anyone give me a hint on this issue?

Thanks

Luis
 
I have a form with a chart that uses a "SELECT DISTINCT TOP" sql
command as rowsource.
Click to expand...

I thought that DISTINCT and TOP were alternatives, not complementary: from
the help file

predicate One of the following predicates: ALL, DISTINCT, DISTINCTROW, or
TOP. You use the predicate to restrict the number of records returned. If
none is specified, the default is ALL.


Hope that helps


Tim F
 

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

Treeview rebuild 1
Rebuilding Treeview 1
Feed Combo Box with a Query 1
Feed a combo box with the results of a query 1
Example Of VBA SQL Statement 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
I manipulate a record that I've put into a listbox (vba) 2

Back
Top