Re: Hellllp!

"Paul" <paul_at_not.a.chance.ie> wrote in message news:MPG.19a4902139f24cd298970e_at_news1.eircom.net...
>
>
> 10001_john_smith_at_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?

He's been programming for 20 years, supposedly.

> Why not implement your idea behind the scenes?

It'd result in over 2 weeks worth of work, I think he'd notice :-)

> > 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...

Yes, aweful though isnt it. Thank Dog ive found a new job, some other poor schmuck will have to maintain it Received on Thu Aug 14 2003 - 13:33:26 CEST