#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0

    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.
    http://dl.dropbox.com/u/2421809/Weather%20Sample.csv

    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?
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,621
    Rep Power
    650
    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.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0
    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:
    http://dl.dropbox.com/u/2421809/Weather.accdb

    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.

Similar Threads

  1. Can't get Query to Display in Report
    By FJTTINMAN in forum Microsoft Access Help
    Replies: 12
    Last Post: March 1st, 2010, 01:36 AM
  2. Bypass Crystal Report Viewer/Display Report
    By wpoopsi in forum ASP Development
    Replies: 0
    Last Post: May 28th, 2009, 03:40 PM
  3. Display field in report
    By eacollie in forum Microsoft Access Help
    Replies: 4
    Last Post: November 4th, 2004, 07:48 PM
  4. Replies: 4
    Last Post: October 13th, 2004, 11:49 AM
  5. Display report in IE and Netscape
    By Steve Schofield in forum ASP Development
    Replies: 1
    Last Post: December 6th, 2000, 04:10 PM

IMN logo majestic logo threadwatch logo seochat tools logo