Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!feeder2.news.heanet.ie!news.indigo.ie!not-for-mail From: Paul Newsgroups: comp.databases.theory Subject: Re: Hellllp! Message-ID: References: Organization: Néant X-Newsreader: MicroPlanet Gravity v2.50 Lines: 43 Date: Wed, 13 Aug 2003 19:13:21 +0100 NNTP-Posting-Host: 159.134.146.243 X-Complaints-To: abuse@eircom.net X-Trace: news.indigo.ie 1060798495 159.134.146.243 (Wed, 13 Aug 2003 19:14:55 BST) NNTP-Posting-Date: Wed, 13 Aug 2003 19:14:55 BST Xref: newssvr20.news.prodigy.com comp.databases.theory:20837 10001_john_smith@hotmail.com says... > I discussed the idea of having a "Repairs" table linked to each row in > Data where a repair has taken place, but that was rebutted with > "dont be a fucking twat", Does your boss know anything about programming db's? Why not implement your idea behind the scenes? > so anyway now he wants me to build a > report that sums all the types of repairs in Rep1,2,3 and calculates > their corresponding amounts. Eg: > 5 A's 40 > 1 B 10 > etc for each repair code. > Not an easy task, but can anyone have a go at this for me, I'm lost as > to where to start. I think that you'll have to iterate through the table (Data?) and keep track of as many sums as there are repair codes... Paul... -- plinehan__AT__yahoo__DOT__com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 p.s. just lacerated a tendon in left hand, so pls excuse typos and tricky abbrevs - TIA.