Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Degree day for Access (access 2000)

    Looking for help designing a database for a small home fuel oil delivery service. I have a basic db that will track customers and order info. But the 2 things I need help with are calculating a customers heating and cooling degree days plus being able to create a report that will print the trucks delivery tickets. Has anyone every worked on such an animal? If so any advice is greatly appreciated. If you know where I could purchase a good off the shelf version of such a software please email me at gbanks@ets.org Thanks...

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Degree day for Access (access 2000)

    I suspect that I am not alone in this, but I don't have the faintest idea what "a customers heating and cooling degree days" means.

    You might get more response if you explain what calculation you are looking for.

    As for the delivery ticket report, it would be useful to provide your actual table structure.
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Degree day for Access (access 2000)

    I should have beem more descriptive.
    Whenever the average temperature on a day is below 65

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Degree day for Access (access 2000)

    So, do you have a table where you store the average temperature on each day?

    And then the calculation you want to perform is to
    * first select just those days where the average temp is below 65 deg, (in a given period) then
    * count the number of days in which the averge temp is 64, 63, 62 etc?

    You could do this with a grouping query, that counts the number of days, when grouped by average temp, where average temp is less than 65, and the date is within the range you want to specify.
    Regards
    John



Posting Permissions

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