Re: limit display of groups, to only groups which have over specific sum of records

If you're asking what I think you're asking, you might, in query design
view, simply try setting the value in the Criteria row to >=50000 for the
field containing the Sum expression. The equivalent SQL might look
something like this:

SELECT
[Your Table].[Your Grouping Field],
Sum([Your Table].[amount paid])
FROM
[Your Table]
GROUP BY
[Your Table].[Your Grouping Field]
HAVING
Sum([Your Table].[amount paid]) >= 50000

This assumes your table is named "Your Table" and you're grouping on a field
named "Your Grouping Field".

"Solsen" <(E-Mail Removed)> wrote in message
news:03ff01c35ada$8f0b7910$(E-Mail Removed)...
> I need to limit the groups displayed in a Query, to only
> those groups whose sum of the "amount paid" field in the
> records of that group, meet the critera of >=50000. How
> can I do this?
>
> Thanks!