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!
Search results for query: *
- Users: TheUltimateChampion
- Order by date
-
Sum or Duplicate records in a recordset.
That is SQL isn't it? I was hoping for VBA. Something like Count Me.Recordset... Thank you.- TheUltimateChampion
- Post #3
- Forum: ANSI_SQL
-
Sum or Duplicate records in a recordset.
How do I count the number of times a field has duplicate data in a Record in a Table? Example: Rows 1,2, & 3 have a Field Heading of Silverwear. In Rows 1, 2 I have "Fork". In row 3, Knife. I would like a (in a Module) to return 2 for a Fork query. I would also like to do this in a query...- TheUltimateChampion
- Thread
- Replies: 3
- Forum: ANSI_SQL
