DataBase design

  • Thread starter Thread starter Deepwater
  • Start date Start date
D

Deepwater

HI All

I need some help.. I am new Data base.. I want to create a
data base which have to enter 24 hours information and get
the average of latest 24 hours.

Any help will be appreciated.

Thanks
 
I need some help.. I am new Data base.. I want to create
a
data base which have to enter 24 hours information and get
the average of latest 24 hours.
Click to expand...

Create a Table with a date/time field containing the
relevant time value and the "information" (you don't say
whether that information is one field or a hundred). To
average over the last 24 hours use a Totals query with a
criterion of
= DateAdd("d", -1, Now())
Click to expand...

on the date/time field.

John W. Vinson
 
check out the aggregate funtion 'SUM' for your queries. They are the ones with
the funny looking 'E' button when in query design mode.
 
Back
Top