1. the original table - this has 9 columns (one of which is a calculated column)
2. The comment table - this has 3 columns
Problem 1:
where should I do the calculations so tht the comments align as shown: I realise that the 3rd column is where I can use an expression.
Problem 2:
Time to Test drive for FORDS - 2 days is very good and 14 days is good (so when reporting "good" results it is all days between 0 and 14) - so some FORDS cars can be both good and very good.
Would it be best to do one flat table - I suppose that would work best?