Click here to Skip to main content
15,888,610 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Is there anyone who can help me about my issue in crosstab? I need to get the sum of the column Total hours

This is what i need.
Ref No | Order No | Total Hours| January | Total
RF-0121-00 | 5350-1403-001 | 63 | 56 | 119
RF-0121-01 | 5350-1403-002 | 100 | 232 | 332
Total 163 288 451

*the column month is the project total

This is the result i get
Ref No | Order No | Total Hours| January
RF-0121-00 | 5350-1403-001 | 63 | 56 63
RF-0121-01 | 5350-1403-002 | 100 | 232 100
Total 288

in crosstab expert i have:

in columns
>tblHours.Month

in rows
>tblHours.Ref_No
>tblHours.Order_No
>tblHours.Total_Hours

in summarized fields
>tblHours.Project_Total
>tblHours.Total_Hours



Thank you
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900