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 Chriss Miller 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 tmcfar
-
Advice on combining records...gotta be better way...
Hi rac2, That's pretty much what I have tried to do. My data comes from a second system so I have no control over the format of what I receive. Thanks for input. Tom- tmcfar
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Advice on combining records...gotta be better way...
Hi, This code works for me...but it seems long and convoluted. Does anyone have a better / cleaner way to do this? I have ... EmplID Action_Reason Effective_Date 123456 'Return From Leave' 2004-06-08 123456 'Leave of Absence' 2004-05-19 123456 'Return From Leave' 2004-06-09 I need...- tmcfar
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Query Structure Problem - Missing something obvious
For some reason, I couldn't get Access to handle the nested query due to an error in the FROM statement. However, when I split it out into two queries....it worked just fine. Thanks, Tom- tmcfar
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Query Structure Problem - Missing something obvious
Query Question: This : SELECT tblAttendancePoints.[EmpID], Max(tblAttendancePoints.PointsDate) AS MaxOfPointsDate, tblAttendancePoints.Total FROM tblAttendancePoints GROUP BY tblAttendancePoints.[EmpID], tblAttendancePoints.Total HAVING (((tblAttendancePoints.[EmpID])=179709)); Returns...- tmcfar
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
