Ok thanks!
Solved!
knoty
Last Activity: Jun 17 '12, 01:38 PM
Joined: Jun 15 '12
Location:
-
Thx Rabbit,
Sorry about the code tags.
I'm not a programmer and I actually don't understand the code very well.
I used the crosstab wizard to generate that code. I fiddled with the wizard but got stuck with the code in my previous post that came closest to what I was looking for.
What I need are 2 calculations as column headers.
1. Sum of Duration for each session type
2. Count of sessions...Leave a comment:
-
Thanks Rabbit for the tip,
However, I have not been able to achieve complete results but here is what I got.
I only managed to get this using the Crosstab_wizard
cRegNumber - cName - cPrgmType - SumOfnDuration - FI - IS
2012-06-01 - Gregory - ESU - 2 - 1 - 2
The sql code generated is attached below. Hope you can advice me how to...Leave a comment:
-
Generating summary reports from 2 tables with multiple calculations
Hi anyone,
I need help here!
Client Table
1. ClientId - Autonumber (Primary Key)
2. Client name - text
Session Table
1. SessionId - Autonumber (Primary Key)
2. sCid - Number (Foreign Key refers to Client.ClientId )
3. SessionType - Text (values = "T1"/"T2"/"T3"/"T4")
4. SessionDuration - number
5. SessionDate - Date...
No activity results to display
Leave a comment: