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: *

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

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