DataBase design

[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

 

[John W. Vinson [MVP]]

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.

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())

on the date/time field.

John W. Vinson

 

[Jessestonecedar]

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