I need to display the amount of records in each region of the query somthing like this:
CANADA - ONTARIO - residential properties - price range 100 000 - 200 000
Toronto (35)
Mississauga (3)
Dundas (4)
Oaklands (7)

with the # records display next to it in the repeat region, then you would click on say Toronto and get a list of the (35) records, I know I seen this before I just cannot find anything on it, any ideas??

You could make a query in the database, using a COUNT statement. What kind of db are you using?

GL

Matt Millican
InternetMill.com
www.internetmill.com
(Win XP Pro / DWMX / Access XP / ASP / VBscript / PHP / MySQL)