Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Budster13

    Conditional Formatting Problem

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

    Conditional Formatting Problem

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

    Report Based on Date Query To Track Jail Inmate Transports

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

    Report Based on Date Query To Track Jail Inmate Transports

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

    Query Using Variable Dates

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

    Query Using Variable Dates

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

    Query Using Variable Dates

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

    Query Using Variable Dates

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

    Query Using Variable Dates

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

    Query Using Variable Dates

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

    Query Using Variable Dates

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

    Query Using Variable Dates

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

Part and Inventory Search

Back
Top