 |  |  |  |  |  |  |  |
How to determine the same numbers in visual basic
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Greetings!
Anybody have idea how the determine the same numbers in 100 records. For example there are 100 inputted numbers in the database file. These numbers, some numbers have the same value.
Anyone know to determine these numbers and display like this.
input
100 numbers inputted in the database file
sample output.
Number ...................... total number with the same value
34 ............................... 20
2 .............................. 15
78 .............................. 36
5 .............................. 9
17 .............................. 11
56 .............................. 8
3 .............................. 1
the numbers from the left is the inputted numbers in the database file. and the numbers from the right is the total of how many times these numbers were inputted or total numbers with the same value.
Thanks in advance.
Anybody have idea how the determine the same numbers in 100 records. For example there are 100 inputted numbers in the database file. These numbers, some numbers have the same value.
Anyone know to determine these numbers and display like this.
input
100 numbers inputted in the database file
sample output.
Number ...................... total number with the same value
34 ............................... 20
2 .............................. 15
78 .............................. 36
5 .............................. 9
17 .............................. 11
56 .............................. 8
3 .............................. 1
the numbers from the left is the inputted numbers in the database file. and the numbers from the right is the total of how many times these numbers were inputted or total numbers with the same value.
Thanks in advance.
Last edited by locsin; Apr 6th, 2009 at 2:56 am. Reason: to improve screen display
What about simply using a COUNT on the database table !!!
something like the following
something like the following
sql Syntax (Toggle Plain Text)
Last edited by debasisdas; Apr 6th, 2009 at 4:25 am.
Share your Knowledge.
|
Similar Threads
- help with this code (VB.NET)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: replacing variable data..(pls very urgent)
- Next Thread: Windows email and vb6
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
