Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to show if last inspection date is > 1 year!
SELECT tblInshoreFishHandling.intHarbourCode, tblInshoreFishHandling.txtLocalName, tblInshoreFishHandling.chkOutOfService, tblInshoreFishHandling.intFacilityCode, tblInspectionInformation.dtInspectionDate FROM tblInshoreFishHandling INNER JOIN tblInspectionInformation ON...- Makita92
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How to show if last inspection date is > 1 year!
Hi Everyone, I am going to try and explain what I want and I hope that it makes sense. First I have a database that contains multiple tables (Listed below is only the fields needed). Harbour Table Harbour Code Harbour Name Facility Table Facility Code Harbour Code Inspection...- Makita92
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
