Hellllp!

Hi, my boss doesnt believe in normalisation/referential integrity/database theory PERIOD.

I pay the cost everyday.

Todays jaunt into insanity is as follows:

We have a table of data (called Data) that contains 30 something fields including:

"Repair 1"
"Amount 1"
"Repair 2"
"Amount 2"
"Repair 3"
"Amount 3"

The repairs(1,2,3 up to three repairs per row in Data) contain repair codes that link to another table called "Repair Codes"

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", 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. Received on Wed Aug 13 2003 - 06:05:32 CDT