I think what you are asking for is a query "select all records from a table
with a date entry that is before some selected date"
A query something like:
SELECT * from table where
[date] < [selected date]
Note: you never actually see this bit of code if you use the built in query
builder, just drop in the fields you want in your result and fill in the
criteria for the [date] field (< [selected date] or if you are interested in
any before today : < now())
Should get you started
by the way: All caps ==> shouting at the group and shows anger (is this
what you intended?)
Ed Warren
