Search results

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.

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...

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...

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...

What it appears to me is that it is reporting a "count" of entries, not the total hours. That's what I perceive anyway.

Thanks for that info. I have learned quite a lot from you already, even though my problem is not fixed. I'm attaching this again, and hopefully you still have my post explaining my problems.

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...

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...

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.

Yep, I'm still working on it. I sent you a post yesterday. I think it was the same as the one I sent last week, but anyway. I guess I can just say hi two more times and I'll be eligible to post my data base. You'll need to explain to me how to do that. The other thing that concerns me is...

Here I am back again. I did all the things suggested. I copied the code straight from the post and that got rid of the red line. I put it in the report properties event line like you said. It still didn't work. I'm so bummed:(. I only have 6 posts (including this one). By the way, where...

OK, here we go again. I copied the codes straight from the post, entered them, and ran the report, still getting the same thing. I have an individual who has 200 hours, 39 minutes and it comes up 8:39. Frustration is a mild word for what I'm feeling. I only have 5 posts (this will make 6), so...

Well, here I am again. I did as you said and opened the properties sheet for the whole report. I came to the point of entering the function. I got to the line var = Split etc. and when I tabbed to go to the next line a box opened and said "Compile Error: Expected: list separator or)" and the...

Thanks again Mark, but I already copied all that stuff from #6 and couldn't figure out where to put it in the report. That was what I was asking in the first place. I went to report design and tried putting the code (using my [clock out 1] and [clock in 1] in the control source for the sum...

Just a note on the above, I have been making this work by Exporting the report to Excel, then formating the hours column to [h]:mm and it turns out right. I would like to not have to go through all that and just have it turn out right in the report.

Thanks Mark for your quick reply. I do a query that gives me each student's hours daily. I use Report Wizard to formulate my report. I group on the student's last name, then group on first name, summary options I Sum on total hours (summary only). I realized when I counted up the actual hours...

I have a similar problem to the one above you just answered. I am also doing a Date/Time field in which I enter the time of day an individual clocks in and out. When I query individual times it gives me accurate hours and minutes for each individual. But when I try to do a total for a week or...