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 TouchToneTommy 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 AndreQ1
-
Quick update names question??
This doesn't specifically address your problem but I STRONGLY suggest not using reserved words as column names. Too easy for the system to get confused. Stay away from column names like User, Name, Table, Field, ID and the like.- AndreQ1
- Post #4
- Forum: Microsoft: Access Other topics
-
Selecting Information from two different tables
SELECT Sales.SalesColumns , Staff.StaffColumns , Bonus.BonusColumns FROM Sales LEFT OUTER JOIN Staff ON Sales.ID = StaffID LEFT OUTER JOIN Bonus ON Staff.ID = Bonus.ID The order you present the tables is: TableWithAllRows LEFT OUTER JOIN TableWithSomeRows. The...- AndreQ1
- Post #5
- Forum: Microsoft: Access Other topics
