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
 
Back
Top