Hellllp!
From: John Smith <10001_john_smith_at_hotmail.com>
Date: Wed, 13 Aug 2003 12:05:32 +0100
Message-ID: <bhd5th$1072j8$1_at_ID-126646.news.uni-berlin.de>
Hi, my boss doesnt believe in normalisation/referential integrity/database theory PERIOD.
Date: Wed, 13 Aug 2003 12:05:32 +0100
Message-ID: <bhd5th$1072j8$1_at_ID-126646.news.uni-berlin.de>
Hi, my boss doesnt believe in normalisation/referential integrity/database theory PERIOD.
"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
5 A's 40
"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:
1 B 10
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 - 13:05:32 CEST