Results 1 to 5 of 5

Thread: Generate Dates

  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: Generate Dates

    Hi All,

    I have a question that I hope someone can answer. I am trying to create a log for all of our deliverable reports.

    Each report has a start date and a frequency in which we produce it. The frequencys range from Daily to Yearly. What my manager would like to do is run a report that will show every report that should be published on a given date, so for example they would enter a date and the report would list all reports that are due to be published on that date.

    Now I would like access to do the grunt work so that I don't have to enter all the report dates manually. I am really not sure what the best way to go about this is as my design skills are limited and I have the feeling I may need to do some VBA which is fairly new territory for me. I feel the different frequencys maybe an issue as the daily reports can be M- F or S - S.

    I hope I have explained myself clearly and that someone is able to help ! Thank you in advance !

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'm not sure I completely understand what you want to do. I get that the reports need to be rostered. I don't think I understand what you want / where you are stuck.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2009
    Posts
    2
    Hi Startrekker

    My problem is how I go about achieving this basically.

    For example having a list of reports that all start in april. How can I then run a report to see what reports are due on say the 6th December.

    All reports are different in terms of frequency and days due

    Thanks

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    it all depends on how you store the update information.
    you could stoire it as an absolute date in the report detsails so you query that table to find what reports are due for a specific date. (you can alos query which reports are overdue and so on.

    however I'd suggest you consider storing the last date that report was run amd store a code that identifies when that report type should be re-run....

    why?
    if someone decides to change the report interval you would have to go in and find every report which used the old interval.. storing the intervalk in another table associated with the report by code means you change once and the changes automatically ripple through the data.

    the down side is you have to do some basic maths to find the next report date. (pretty trivial.. just use the dateadd function in your query).

    there are other plusses and minuses but I'll gloss over those for now
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Agreed. Storing the date each report was last run along with a field or fields that detail the frequency of each report would seem to be the best way to go.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •