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: alphadude
  • Content: Threads
  • Order by date
  1. alphadude

    Query doesn't seen to MAX

    Table is tblReview Fields are Pln# PN CND Date Rcvd SELECT tblReview.[Pln#], Last(tblReview.PN) AS LastOfPN, Max(tblReview.CND)AS MaxOfCND,Last(tblReview.[Date Rcvd]) AS [LastOfDate Rcvd] FROM tblReview GROUP BY tblReview.[Pln#] HAVING...

Part and Inventory Search

Back
Top