Lou wrote:

> Is it possible do use the Extract function to Group-By in a query?
> I periodicaly have a need to report summary totals over several
> months and the only way that seems logical is to group by Extract
> (Year from date), Extracte (month from date), sum(value) etc....
>
> I am currently only using FB1.0x FB 1.5 is in my near future for
> this project. Will D/l and try on FB 1.51 first chance I get.

You can group by UDF, so use some UDF that extracts months/years from
dates. I highly recommend rFunc UDF library:

http://rfunc.sourceforge.net


HTH

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org