Hello everyone,

Is it possible to constrain x number of ("top x") records based on reordered summary field?

Fields:

-Name

-Item

-ItemCount = Summary (count of Item)

SubSummary: Name

SubSummary: Item (reordered based on Summary of ItemCount)

End Result:

Jack(Name)

------Table 5(Item ItemTotal)

------Chair 2

------Stool 1

------Pen 1

------NoteBook 1

------Eraser 1

Mary

------Table 8

------Chair 3

------Stool 1

------Pen 1

I would like to be able to see only eg. top 3 Items for each Name.

Many thanks!

ConstrainPrint.zip

Yes thats pretty straight forward, read here:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

and be aware that omit of multiple record has been improved since the article was made.

Hope this is sufficient clue??

--sd