Results 1 to 3 of 3
  1. #1
    pooh83 is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2010
    Posts
    2

    I need help

    Dear all,

    I need some help here....

    I Would like to come up with a report on the daily readings of a Lightning Warning system.

    It will have the fields :

    Time | Weather Condition| Reading | Alarm Level| Read By | Status

    and these are to be done on a daily basis.

    Thing is i need to generate a consolidated report for the whole month to my landlord. Indiciating on the readings and closure.



    I have currently created 31 tables for example with a type up of all the readings for the month of DEC for example.

    How do I make it into a report filtering the days that the vicinity was CLOSED ?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    I'll help out a bit by telling you you do not need 31 tables for this. All of the records should be in one table with a date field in each record.

  3. #3
    pooh83 is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2010
    Posts
    2

    Wink

    Hi bro, thanks for ur reply.

    I will try it out today thanks !

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums