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 / Queries / November 2005

Tip: Looking for answers? Try searching our database.

Query to list delinquent entries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AnnG - 03 Nov 2005 20:22 GMT
Please help with a query that will provide a list of delinquent entries.  

I have an “INDICATOR” table with a field named “Indicator#” and a “DETAIL
RECORDS” table that also has a field with the “Indicator#” and a field named
“DateOfData” – along with many other fields.  I need a query that will
provide a list of all the records from the INDICATOR table that do not have
entries in the “DETAIL RECORDS” table greater than a date that will be
entered in the “DateOfData” field of the query.

If I have not made my problem clear, or if you need more info to help me,
please so inform.

I am very much a novice and will greatly appreciate any help offered.  Many
thanks in advance.
Hafeez Esmail - 03 Nov 2005 22:39 GMT
Step 1)  Start by using the Query wizard (create an 'unmatched' query)
Step 2)  Modify this query to include your specific criteria.

If you need further help with step one or two, please respond to this post
Hafeez Esmail

> Please help with a query that will provide a list of delinquent entries.  
>
[quoted text clipped - 10 lines]
> I am very much a novice and will greatly appreciate any help offered.  Many
> thanks in advance.
 
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.