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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using query to count number of duplicated records and output a single value
yes correct. Sorry when I formatted it here it looked seperated but after submitting it did not leave spaces. The model number is combined I just want the first model number to report the number of duplicates throughout the database So if there are 3000 gk125's than the first row with gk125...- Viktoriah
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Using query to count number of duplicated records and output a single value
Hey guys, I am new to access and I can't seem to figure out my problem. I am trying to create a column that will show the number of duplicates that I can carry to the end of the report later on. I have a file that has many duplicates, I want to count the duplicates, I have been reading about...- Viktoriah
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
