Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / April 2005

Tip: Looking for answers? Try searching our database.

FORMULE FOR FORMATTING DATE ENTRIES FOR NOTIFICATION AGAINST A SP.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom Norban D' cruz - 12 Apr 2005 06:36 GMT
Pls send the formulae for expiry notification for a set of date entries
Ofer - 12 Apr 2005 10:51 GMT
Can you be more specific

>-----Original Message-----
>Pls send the formulae for expiry notification for a set of date entries
>.
Ed Warren - 12 Apr 2005 12:57 GMT
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

> Pls send the formulae for expiry notification for a set of date entries
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.