Hi
 I have a field in a database which contains the date the data was entered,
 Is it possible to take a count of the number of fields that has been 
entered in the last 24 hours?
 
thanks
Brendan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Brendan O'Grady" <9843922@s...>
Subject: [access_asp] Date function in asp


: I have a field in a database which contains the date the data was entered,
: Is it possible to take a count of the number of fields that has been
: entered in the last 24 hours?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SELECT
    Count(DateField)
FROM
    Table
WHERE
    DateField >= DateAdd("h", -24 Date())

(or something similar - check your Access documentation)

Cheers
Ken