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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kammsba
-
Building a Search By Distance Form
I'd like to build a search form which allows members to get results of school districts within so many miles of their own district. Is this possible? How do I start? Thanks! -
Update Query Returns Nothing
I'm not getting any results. No error messages. UPDATE History SET DistrictNameID = (SELECT SchoolDistrictNameID FROM dbo_Client WHERE ClientHistoryID > 1 AND History.Member_ID = dbo_Client.ClientHistoryID); This hasn't worked, either: UPDATE History INNER JOIN dbo_Client ON...- kammsba
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Update Query on Two Linked Tables
Table dbo_Client and Table History are linked (one to many) with dbo_Client.ClientHistoryID=History.Member_ID I have created a empty field in History called DistrictNameID. I want dbo_Client.SchoolDistrictNameID to copy into (update) History.DistrictNameID, but only in those records where...- kammsba
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
