I will try that when I get to work. I will probably alter it some
because I am using C# and a Windows form to do the groupby and
presentation. I just want a dataset that has the info compiled

Location 1 4/2/2003 2 $5,423.00
Location 1 4/21/2003 1 $1,280.00
Location 2 ...
Location 2 ...

And use C# to format the thing.

Thanks for the help. For some reason I am just having trouble with this.

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!