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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
using the values held in columns
hello, i'm writing a query that will omit all records which are up to date. each record has recordnumber as its key, but because the dates are not unique, it dislays records which are not up to date as well. how can i omit all records with the same record number?
