Search results

  1. J

    Query to fill in missing dates

    CJ_London and arnelgp, It seems the two of you are working harder to solve this than I am. I do appreciate the suggestions and all the ideas. This community is much better and more responsive than I could have hoped. Thanks to both of you. You've saved me a lot of time doing stupid...
  2. J

    Query to fill in missing dates

    Arnelgp That is a pretty impressive way to solve the problem. Thanks for the additional view. I would have never thought to do it that way (obviously). I'll put this to work for me today. Thanks, James
  3. J

    Query to fill in missing dates

    CJ_London, That makes sense. I guess I'll create a table of some form and use it to handle all the missing dates. I hate doing it this way because now I've got a never-ending maintenance job, but at least the system will work like I want and I can come up with some auto-update routine on the...
  4. J

    Query to fill in missing dates

    This is probably easy to do, but I am not smart enough to figure it out. I have to create a time-tracking database for my company. For part of this, I need to create a report showing days worked and not worked. The supervisor will enter a starting date and an ending date. I have a table that...
Back
Top Bottom