Re: Group by Query

On 7 Apr, 10:31, Jens Teich <spamt...@[EMAIL PROTECTED]
> wrote:
> > I need new table with aggregate data groupped by Code, Bank Year and
> > with total of Total:
>
> > Code =A0 =A0 Bank =A0 =A0 =A0Year =A0 =A0 =A0 Totale
> > 123 =A0 =A0 =A0 Bank1 =A0 =A0 2007 =A0 =A0 =A0 2500
> > 123 =A0 =A0 =A0 BanK2 =A0 =A02007 =A0 =A0 =A0 =A01700
> > 124 =A0 =A0 =A0 BanK1 =A0 =A02007 =A0 =A0 =A0 =A05500
>
> You don't need a new table. All you need is a summary field based on
> sum of Totale and a subsummary layout part ( when sorted by Code and
Bank =
).
>
> The rest of the work FileMaker will do for you.
>
> Jens
>
> --
> Free PlugIn for Regular Expressions with
FileMaker:http://jensteich.de/reg=
ex-plugin/

Hi,
I don't want a re****t,
but I need a ****tal that show aggregate data.
Anna