If I understand you correctly, you have a varying number of records per
city. To display results from the first 10 cities you have to do a lot of
arithmetic to track where one city stops and the next begins.
I did this at http://www.bike70th.com/ where the grouping was by Day.
Let me know if you want the template.
best, paul
At 12:50 PM 9/27/00 -0400, you wrote:
>Does anyone have any suggestions as to how when I tell the query to output
>1 - 10 it doesn't output the first 10 hits in the top group but counts
>from a sub group?
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
