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!

Register Log in
  • 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!

Search results for query: *

  • Users: tmcfar
  • Content: Threads
  • Order by date
  1. tmcfar

    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...
  2. tmcfar

    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...

Part and Inventory Search

Back
Top