Re: SQL command to Access

Tech-Archive recommends: Speed Up your PC by fixing your registry


"Ella" <ellakayeekwan@xxxxxxxxx> wrote in message
news:1142032031.179655.123800@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I am getting missing operator error with "COUNT(DISTINCT T1.[Maturity
Date]) " in the following SQL command.

Access SQL doesn't support COUNT(DISTINCT). The workaround is to create a
query that performs the DISTINCT and then use that as the source of your
COUNT() query.


.

Relevant Pages

  • Re: Mail Merge differences between 2000 and 2002
    ... "Opening This Will Run the Following SQL Command" Message When You Open a ... Doug Robbins - Word MVP ... query), and second the dialog is just not wanted! ...
    (microsoft.public.word.mailmerge.fields)
  • Re: return a value from sql table
    ... Note the COALESCE function which ensures the SELECT will return a "1" even ... if the results of the query are NULL. ... conditions in the WHERE clause of the SQL command. ... Private Function getNextSeq() As Integer ...
    (microsoft.public.dotnet.languages.vb)
  • Re: why is sqldatareader so slow ?
    ... The sql command is still running when the datareader starts to ... Marc ... >a) How long does it take to execute the query with the SQL Server tools? ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Query logic concerning dates
    ... The command text part of the query is really a SQL command. ... You can set this number to 1 and sort backwards ... easily create a macro automatically by using the Macro Recorder an manually ...
    (microsoft.public.excel.programming)
  • Re: SQL Error Message
    ... Opening this document will run the following SQL command: ... Select *from (whatever query I am pulling from) ...
    (microsoft.public.word.docmanagement)