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!
-
How to find the lowest values of a table
I have a table with Journal Entries and I need to retrieve all the fields for each record grouped by EntryNumber where LineNumber is the lowest. The table looks like this ID EntryNumber LineNumber Amount 1 1 1 20 2 1 2 20 3 1 3...
