Recent content by billyw1953

I have sent your web address to our network administrator along with my recommendations that we use your service should the need ever arise. It's the very least I can do considering the assistance you have given me. Best regards, Billy

Got it, I will do just that and thanks for the tip. I tried messing with the sql the mailman sent in and got it to work by playing with the date ranges a little. Don't know how or why it's working though, isn't that scary? Anyway, I don't trust what I did in sql, it would work for an end of...

Sorry if I wasn't clear enough in my description Pat but I am not misreading the results. If you specicify a date range from 1/1/04 to 1/27/04 you will get 17 rows and Wike is #18 and not in there. He's not in there because he did not work at all in that date range. The problem is I need to see...

Thanks for the help, I'll play with it a while and see if I can get exactly what I need.

Changed the ProgramAssign clause to "where" and the join types to a left join (if I understand you correctly). In my mind, if I have applied the Nz function correctly under "TotalTime" then someone who has not worked during the period I specify should show a "0" and my criteria is asking for >=0...

Thanks Pat your suggestions are always very much appreciated, I had already tried changing the join types before I ever posted but still cannot get the query to show all 18 employees. If only 17 worked in January, it will not include the one who didn't work. Billy

My crude little query is actually working great with one problem. I have 18 employees working a program and the query will only show me 17. The one it's not showing is someone who DID NOT work at all during the [Beginning Date] and [Ending Date] I specified (1-1-04 to 1-23-04). I deduced quite...

Thanks Pat, so far the code works perfectly. I think I understand what you are saying, I will probably make a copy of my database and enter some dummy times in there so I can watch for margins of error as it grows. I appreciate your help but embarrassingly enough for me I just could not quite...

It was probably fairly routine for you, but I cannot express to you and the others that answered my post just how much I appreciate your help. My database is working perfectly now that the total time issue has been resolved. I read quite a bit before I ever posted and one of the things I keep...

Jon K would you look at the attached sample database you created. Your report with very few exceptions mirrors the one in my original database. When I utilized your functions, the report was completely accurate using days, hours, minutes, and seconds. However, I really need to see only hours and...

Thank you very much Jon, this code works perfectly. I truly appreciate the time you took to help me out with this.

Thanks for the help, used the datediff(s) to convert the time to seconds in a query and it totaled up just fine. Checked the math and 15 min converted correctly to 900 sec. Now the proper formating has me stumped. I downloaded your sample data base and looked around but probably don't...

I have looked through the threads and could not find anything on date and time calculations, if I missed something please forgive my repeated question. I have a table (datetimeloctable) which calls for both date and time field entries ie; datetimelocbegins and datetimelocends I am keeping...