trevor2486
Posts: 1
|
| Posted: 10/06/2009, 6:57 PM |
|
Hi, does anyone have suggestions that might help me out in this situation?:
I have a results table roughly as follows:
recordNumber
userID
resultType
resultValue
resultDate
so user results are stored in this table and a user will have multiple results records (several values and types) for a given date.
I want to set this out in a grid where column heading is resultType, row heading is Date and cell content is resultValue.
I can't see how to achieve this through the builders - any ideas gratefully accepted!!
Thanks,
Trevor
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 10/06/2009, 7:49 PM |
|
trevor2486,
You are talking about a crosstab query. Here is a link that can get you started: http://www.google.com/search?hl=en&rlz=1C1GGLS_enUS329U...m&aq=f&oq=&aqi=
And yes you are correct there are no CCS builders for crosstab queries.
|
|
|
|
|
