Notices

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.

Thread: Report - Display Daily Stats

Results 1 to 3 of 3
Share This Thread →
  1. #1
    vahnx is offline Registered User
    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
    June7's Avatar
    June7 is offline Moderator
    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    649
    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

  3. #3
    vahnx is offline Registered User
    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.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates