|
| Iniciado por guest, 05,mar. 2015 03:56 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 05,marzo 2015 - 03:56 |
| Hello I know it right in front of me. but I am going to ask. I have a list of 200,000 names or more [ FName, LName ] I would like to know how many name are there IE 20 FName of Mark/ 250 FName of John / 130 FName of Jim. Now I don't know the name(s) in the list.. I am thinking I use FileToArray (Function).. But as Andy tell's me, I am over thinking it..? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,marzo 2015 - 11:05 |
Hi Mark
1. A query getting all records, with only the fields you need
(firstname, lastname, whatever you need to count)
2. a hreadfirst/while not hout/hreadnext on the query, on the field to count
3. You count till the value changes
That's all
As it's a query, you can do that on any field, even if it's not a key,
and you can do one loop for each field to count without any extra data
access
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
NEW: WXReplication, your open source replication system is available on
my web site!!!
WXShowroom.com: Show your projects!
More information on http://www.fabriceharari.com
On 3/4/2015 9:56 PM, Mark Nelson wrote:
Hello I know it right in front of me. but I am going to ask. I have a
list of 200,000 names or more [ FName, LName ] I would like to know how
many name are there IE 20 FName of Mark/ 250 FName of John / 130 FName
of Jim. Now I don't know the name(s) in the list.. I am thinking I use
FileToArray (Function).. But as Andy tell's me, I am over thinking it..? |
| |
| |
| | | |
|
| | | | |
| | |
|