Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
December 18th, 2012, 01: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, 04: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, 04: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, 02:36 AM
By wpoopsi in forum ASP Development
Last Post: May 28th, 2009, 04:40 PM
By eacollie in forum Microsoft Access Help
Last Post: November 4th, 2004, 08:48 PM
By squire in forum ASP Development
Last Post: October 13th, 2004, 12:49 PM
By Steve Schofield in forum ASP Development
Last Post: December 6th, 2000, 05:10 PM