December 18th, 2012, 12:46 PM
Report - Display Daily Stats
We have a weather station setup that collects data where I work. What I'd like to do is have a simple report where people can click through a calendar/dropdown to select a date that exists in the database, and it shows information such as the amount of rain or the average wind of the day. This is what I got so far, but can't get the graph to bend to my will, nor allow me to change the date or anything really:
What I'd like to see is something basic like this (the upside down triangle is my dropdown menu):
There's a total of 170,000+ records since we put the station up earlier this year, here's about 100 of them in csv format.
I realize the data isn't normalized but I can worry about that once I get something functional going. Any pointers/tips to getting this work right?
December 18th, 2012, 03:21 PM
Would have to analyze the report and graph structure and some sample data would be helpful. If you want to provide, can upload to a fileshare site such as box.com and post link to the file. Make copy of database, remove confidential info, run Compact & Repair, zip files.
December 18th, 2012, 03:47 PM
Here's some sample data: http://dl.dropbox.com/u/2421809/Weather%20Sample.csv
This is the access database file I've been playing with:
We just basically need some sort of form/report where we can select a date and view the highs and lows of the day selected, etc.
By FJTTINMAN in forum Microsoft Access Help
Last Post: March 1st, 2010, 01:36 AM
By wpoopsi in forum ASP Development
Last Post: May 28th, 2009, 03:40 PM
By eacollie in forum Microsoft Access Help
Last Post: November 4th, 2004, 07:48 PM
By squire in forum ASP Development
Last Post: October 13th, 2004, 11:49 AM
By Steve Schofield in forum ASP Development
Last Post: December 6th, 2000, 04:10 PM