I have a table that consists consists of Date, Value and Result name. I've done crosstab report on it but it is very difficult to do the math that is needed. Is there a way to convert the crosstab to a table where the column, row names would be the fields in the new table? Example:
Current table - date value result name
12/01/2002 10.0 Raw water
12/01/2002 11.0 Final water
12/02/2002 9 Secondary
New table - Raw water FinalWater Secondary
12/01/2002 10 11 9
12/02/2002 15 10 12
I have greatly simplified the tables but I hope you can get the idea.
Current table - date value result name
12/01/2002 10.0 Raw water
12/01/2002 11.0 Final water
12/02/2002 9 Secondary
New table - Raw water FinalWater Secondary
12/01/2002 10 11 9
12/02/2002 15 10 12
I have greatly simplified the tables but I hope you can get the idea.