Jeff, > I don't see how you got the result you quote below. > My query sums the volume figures, grouping by scanid: > that worked as expected (one line per scanid) on my > system when I tested it (version 7.1.2, though I don't > think that matters).
Lemme try it .... Yes, you're right. Sorry! Disregard my commentary about the second view. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]