Summing Sums in records...?

[Hrtlover]

Hi mate,
Thanks again, but now every time i open the report access crashs? :\
Thanks.

[jzwp11]

I downloaded the database I posted yesterday and had no problem opening the report (report2). Did you make any changes to what I posted? If so, what?

[Hrtlover]

i just tried again with the database you uploaded, n it did the same thing..
never got to open the report to look :\

[jzwp11]

I'm not sure what to tell you. You might create a new blank database and import everything from the other database in to it, and see if that solves the problem but I have a feeling it won't. Do you have any issues opening other Access databases?

[Hrtlover]

I know.. :| will the different versions matter? I tried opening in 2007 Access, and 2003 (prefrible) but i can try 2010 if need be. Would that help at all?

But everything else seems fine, i have backups of the database i uploaded at first and they work fine still no other problems.. weird. Must be something in the paramaters or something?

[jzwp11]

I don't think the version will matter. Something strange is going on. I have removed your startup macro and run the compact and repair utility on the attached. Maybe it will work this time.

[Hrtlover]

Nope no good

[jzwp11]

OK then you will have to make the changes to your own working copy by adding a new control to the detail section of the report with the following control source

=[hoursWorked]-(Int([hoursWorked]/5.5)*0.5)

I called this control adjHoursWorked

Then in the control that shows the time worked in HH:MM format, you will have to reference adjHoursWorked rather than hoursworked, so something like this:

=Int([adjhoursWorked]) & ":" & Format(([adjhoursWorked]-Int([adjhoursWorked]))*60,"00")


Then in the group footer, you will have to change the control that does the summing to the following:

=Sum(IIf([workfinnishtime]<[workstarttime],24+DateDiff("n",[workStartTime],[workFinnishTime])/60,DateDiff("n",[workStartTime],[workFinnishTime])/60)-(Int((IIf([workfinnishtime]<[workstarttime],24+DateDiff("n",[workStartTime],[workFinnishTime])/60,DateDiff("n",[workStartTime],[workFinnishTime])/60))/5.5)*0.5))

[Hrtlover]

As soon as i put in those formulas and went to change veiw i got a crash, so theres something in there that its not liking.

[jzwp11]

Can you try it stepwise? Put in the adjhoursworked, save the report and test it to see if it works. If so, then the problem lies in the sum control. If it crashes after the adding adjhoursworked, then it doesn't like that expression, so we will have to find a way around it.

I would make sure that my spelling of the controls/fieldnames are not different from yours.

[Hrtlover]

Yeah mate, all works until the sum formula, then it dies.

[jzwp11]

I had no problem either at work using Access 2003 or at home using Access 2010. I'm not sure where to go from here since I cannot duplicate the error.

[jzwp11]

I might have a workaround but I won't have time to work on it until tonight.

[Hrtlover]

thats ok mate, it fired up in 2010 here! only problem is now the sum control is giving a #error..

[jzwp11]

I move the calculations for the hoursworked and adjhoursworked to the query. See if you have any success with the attached.