I have created a dynamic crosstab report by using the sample in North Wind and made the relevent changes. I have the calander form for the date parameters, the query and the report. I have my column heading as dates and the row headings projects. The values are hours from this query expression Hours: Sum(((DateDiff("n",[StartTime],[EndTime]))/60)). My problem is that the Totals column and row do not convert the hours correctly.
I want the hours fixed with 2 decimals. For example; when I add 1.00 + 1.50 = 2.00 in totals column and 1.00 + 1.75 = 3.00 in totals colume. Same problem in the Row totals. My thanks for your help? [sig][/sig]
I want the hours fixed with 2 decimals. For example; when I add 1.00 + 1.50 = 2.00 in totals column and 1.00 + 1.75 = 3.00 in totals colume. Same problem in the Row totals. My thanks for your help? [sig][/sig]
