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 wOOdy-Soft 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 megwich
-
Selecting a different col based upon another col
Hi I have a table that has the following cols RouteID,TimeDepart,TimeArrival for example a row may have 1020,700,-1 i.e. RouteID = 1020, timedepart = 700, TimeArrival = -1 most rows conform to a timedepart having a positive value and the timearrival being -1 (effectively stating that the...- megwich
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
