I am building an Access Database application that will help me analyze
staffing levels for landscaping teams across the US.  I would like to
find a database that I could import into Access that would tell me the
average temperatures (highs and lows), average rainfall, and average
snow fall by zip code by day, week or month. I would also like a
database with the climate regions by zip.

---

Clarification of Question by fdic-ga on 26 Feb 2005 18:13 PST

I wanted to add that the data does not need to be free.  I am willing
to pay a reasonable amount.

---

Clarification of Question by fdic-ga on 21 Mar 2005 09:42 PST

getting the information out of Access is not the problem.  I don't
have a data base on climate to pull from...

You can query on year/month fields in Access using a date range.  Here
is what the query designer window looks like:

   Field:      Year          Month           Year          Month
   Table:      MyTable       MyTable         MyTable       MyTable
    Sort:
    Show:
Criteria:      >Year([d1])                   <Year([d2])
      or:      >Year([d1])                   =Year([d2])   <=Month([d2])
               =Year([d1])   >=Month([d1])   <Year([d2])
               =Year([d1])   >=Month([d1])   =Year([d2])   <=Month([d2])

And for this question, you could start here:

[ http://www.ncdc.noaa.gov/oa/climate/research/ushcn/ushcn.html ]