Search results for query: *

Thanks to all of you who have responded to my question. You all have some really good ideas, but DaleWatson123321 seems to have hit the home run so to speak. I will email the program to you and we can begin to analyze the best approach. Budster13

I wrote a time card program in Excel 2000 (originally in XL97) that has been working now for two years. I have just discovered that there is a flaw in the sick day accumulation portion. Here's the way it's supposed to work. Our civilian employees can accumulate up to 45 sick days at a rate of 9...

Dan, Thanks for your response, but it's a little more complicated then this, I think. I'm also not very adept with VBA. Budster13

I’ve written a database with the assistance of Tek-Tips Forums programmer SCRIVERB, but have run into a new problem that I thought was working correctly. I’ve tried to reach SCRIVERB though his email shown in his profile, but it’s currently not active. I need a report that tracks the number of...

Bob, I just got a chance to open the latest version. Absolutely great! It's everything I wanted it to do. I'll make some minor adjustments and send it back to you just for your archives. Also, thanks for explaining the DAO stuff and why the queries only run with the form. You have really helped...

Bob, I still don't have any data in the BegBillingDate field. Note I had to convert the db to Access 2000; did this change things? I'm sending you the same db you sent me now named Prisoner1 and a working copy of the db I developed with your tables and queries added named USMS v1.0a. Notice we...

Perfect Bob. When you send me the prompted query, please explain why there's no data in the [BegBillingDate] field. Temporary place holder, or what? Thanks a million. Budster13

Bob, I'm sorry I confused you. It's true that the USMS will not pay for the last day a prisoner is in custody/released, however, Green does not have a release date, therefore should be billed for the 30 days of June. I have written several excel and access programs, but nothing as complex as...

Bob, we are very close now, but still a few problems. Here's how I populated the tables so you can run the same way I have. I think this covers all the possibilities, but check me out. [PrisonerName] [StartDate] [ReleaseDate] Jones 06/01/2002 06/25/2002 Smith...

Wow! No wonder I couldn't figure it out. From it's appearance, I believe this is just what I was looking for, but I'll have to plug it in a little later and I'll let you know. Thanks sooo much! Budster13

xaf294, Thanks for your quick response. We're almost there except for the second (or end)date parameter. We may still have the prisoner in custody at the end of the month or he may have been released sometime earlier in the month. He could also have been in and out of custody in a prior month...

Using Access 2000, the US Marshal Service reimburses our jail for federal prisoners we house at a daily date of $40. I need a database/report that will count the number of days per month times $40 showing each prisoners name and date of birth. The problem I've run into so far is if a prisoner...