Thank you so much for that information. You are assuming I know a whole lot more than I do. Where do I put that information. Is it something I do when I send it, or do I embed it somewhere in the file. I definitely am not accustomed to doing anything that doesn't use the task bars, etc.
Sum Time in Report
- Thread starter abenitez77
- Start date
Also, will that remove those numbers permanently, or just hide them from view of whoever is examining the file? Because I definitely have to keep those numbers in the file. By the way, this is Post #10, so I'm ready to send this data base to you. I'm assuming I just use the attachment above, but I'll need to do the code thing first. Hope we can get this taken care of.
Last edited:
MarkK
bit cruncher
- Local time
- Today, 06:37
- Joined
- Mar 17, 2004
- Messages
- 8,446
Make a copy of your database. Then start hacking sensitive stuff out of it. You can open tables in design view and simply delete fields that contain sensitive info. Check and make sure anything this that needs to work does, since the absence of a field might kill something.
And that's it.
Cheers,
Mark
And that's it.
Cheers,
Mark
OK, I'm going to attach my data base and let you take a look at it. The report that I'm having the most trouble with is "Total Hours by Student Name" whose control source is the query "Total Hours by Student Name". "Year to date Total Hours" report isn't working either. I'm sure whatever is done to fix one will most likely fix all. I just don't know what to do. If you get it fixed (which I'm sure YOU will be able to do), I just need to know how and where you did it. Well, I just tried to upload it, and it is 5.2 MB. So now I will need to deleted a ton of info so I can get it to work. OK, so now I deleted well over half of the entries I've made, (originally I had over 3,000 entries), and I still have 5.19 MB in file size. I don't know what to do now, because if I delete anymore, then there won't be enough data to work with. Got any suggestions now?
boblarson
Smeghead
- Local time
- Today, 06:37
- Joined
- Jan 12, 2001
- Messages
- 32,059
The Sum Of Total Hours text box in the First Name Footer is not set to Visible. So that's why it looks that way. However, I'm looking at it and the report total isn't correct. I'm trying to figure out why. The Name records appear to be fine but the final sum isn't picking up the entire total. (and I'm talking about Lagbolt's sample)
Bob,
Thanks for jumping in here too. It appears the name totals are correct, but they are not. Anything that is over 24 hours is rolling to whatever hour amount is over a multiple of 24. (Example: If the student has 54 hours and 12 minutes, it shows 6 hours and 12 minutes). That was my original problem, along with the fact that the total hours behaves the same. I am entering individual entries in "Short time" format. I don't know how or where to add the "modules" that are a part of my file to correct it. I've read a ton, and what I've read says that these modules will fix it, but I don't know where to put them. I have a year's worth of entries in my unedited file which I did not send to you. The reason I know these totals are not correct is I have actually exported the report into Excel, then formatted the totals column into [h]:mm format, and it gives the corrrect amount. That is how I've been providing my instructors with the correct totals each week. Your help would be much appreciated in correcting that.
By the way, when I opened the file attached, it is opening correctly in Report view. Just not giving the proper totals.
Thanks for jumping in here too. It appears the name totals are correct, but they are not. Anything that is over 24 hours is rolling to whatever hour amount is over a multiple of 24. (Example: If the student has 54 hours and 12 minutes, it shows 6 hours and 12 minutes). That was my original problem, along with the fact that the total hours behaves the same. I am entering individual entries in "Short time" format. I don't know how or where to add the "modules" that are a part of my file to correct it. I've read a ton, and what I've read says that these modules will fix it, but I don't know where to put them. I have a year's worth of entries in my unedited file which I did not send to you. The reason I know these totals are not correct is I have actually exported the report into Excel, then formatted the totals column into [h]:mm format, and it gives the corrrect amount. That is how I've been providing my instructors with the correct totals each week. Your help would be much appreciated in correcting that.
By the way, when I opened the file attached, it is opening correctly in Report view. Just not giving the proper totals.
boblarson
Smeghead
- Local time
- Today, 06:37
- Joined
- Jan 12, 2001
- Messages
- 32,059
I am uploading a revised sample.
See my qryTestAttendance to see that I convert to minutes and then in Total Hours by Student Name I use those minutes because I convert them in the final report fields by using the backslash operator (\) instead of the usual (/) to divide by 60 to get hours (as Integer) and then Mod 60 to return the remaining minutes.
See my qryTestAttendance to see that I convert to minutes and then in Total Hours by Student Name I use those minutes because I convert them in the final report fields by using the backslash operator (\) instead of the usual (/) to divide by 60 to get hours (as Integer) and then Mod 60 to return the remaining minutes.
Yippee!!! If you were close enough I'd give you a hug!! That's perfect. I don't need the count in there. I'll take that out, unless it needs to be there for the report purposes. But that's exactly what I needed. I appreciate you guys so much. Now I can get on with what I need to do. Thanks again, many times.
Bob,
I copied off your report and the queries the way you had changed them. I've changed mine to exactly the same as yours, and when I run my report it won't summarize. I keep getting individual hours with a total for every student. Makes the report about 70 pages long. I have tried going in and doing a report from Report Wizard, and that isn't helping either. For some reason I seem to have lost the abilitity to summarize. Any help you can give would be wonderful. I just returned from Spring break, so that is why I wasn't able to try it out any sooner. Appreciate all you are doing to help me out.
I copied off your report and the queries the way you had changed them. I've changed mine to exactly the same as yours, and when I run my report it won't summarize. I keep getting individual hours with a total for every student. Makes the report about 70 pages long. I have tried going in and doing a report from Report Wizard, and that isn't helping either. For some reason I seem to have lost the abilitity to summarize. Any help you can give would be wonderful. I just returned from Spring break, so that is why I wasn't able to try it out any sooner. Appreciate all you are doing to help me out.
Hi again,
Well I just thought I'd let you know that I'm not sure what I did, but now it is working. I moved the header bar and the details bar closer together, and for whatever reason that seemed to have fixed it. Not sure why, but anyway, it is working now. Thanks again for all your help.
Well I just thought I'd let you know that I'm not sure what I did, but now it is working. I moved the header bar and the details bar closer together, and for whatever reason that seemed to have fixed it. Not sure why, but anyway, it is working now. Thanks again for all your help.
