> ODBC Error Code = 37000 (Syntax error or access violation) > > [Microsoft][ODBC Microsoft Access Driver] Cannot include Memo, OLE, or > Hyperlink Object when you select unique values (va_description). > [snip] > Is that error prototypical of anything in particular? >
Its just what it says it is....... You cannot include a Memo field in the DISTINCT query. At a guess I was say that one of the fields in va.* is a memo field. Regards Stephen. PS. Prototypical is too long a word for a monday morning! -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
