FORMULE FOR FORMATTING DATE ENTRIES FOR NOTIFICATION AGAINST A SP.

  • Thread starter Thread starter Guest
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top