Re: Aggregate Functions

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 04/28/04 

Date: Tue, 27 Apr 2004 20:49:02 -0500

>I am converting our BDE-based Delphi 7 applications to ADO (OleDB).
>There is a report which uses aggregate functions and below is the erring
>statement:  
>
>SELECT MAX(STATUS_DT), MAX(PCT_DONE)
>FROM PROJ_STATUS
>WHERE PROJ_KEY(+) = :PROJ_KEY
> AND DEL_FLAG IS NULL
>ORDER BY PROJ_KEY
>
>The error message is 'Not a single-group function.' I read that OleDB
>does not support aggregate functions. How can I then run the report?

Oledb doesn't support any functions. Function support depends on what your
database and oledb driver support.
You need to include what database and oledb driver you are using when you ask a
question about SQL syntax and it is usually a good idea when asking any question 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: Urgent Help required - Agregate Error
    ... report's record source. ... Simple aggregate functions like Sum ... > in the report. ... > earlier posting I've received hundreds of spam mails. ...
    (microsoft.public.access.reports)
  • Re: .Net 2.0 DataTable have a lot of lacks?
    ... The DataTable .Select method does support "some" ... aggregate functions like SUM and AVG. ... > so i can load data from remote service and manipulate it and after i ... > have some Project that extend DataTable abilities? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: reports: sum and avg difficulties
    ... had to be changed to Numbers for the calculations to work on the report. ... >The aggregate functions can only ... >They are not aware of controls in the report. ... >The error message actually implies that you may already be ...
    (microsoft.public.access.reports)
  • Access Projects Help
    ... In my Access Projects Report, I cannot use any aggregate functions, sum, avg ... In the detail section of my report, in a text box called txtTime I have the ...
    (microsoft.public.access.reports)
  • Access Projects Report
    ... In my Access Projects Report, I cannot use any aggregate functions, sum, avg ... In the detail section of my report, in a text box called txtTime I have the ...
    (microsoft.public.access.reports)