
November 14th, 2007, 10:16 PM
|
|
Registered User
|
|
Join Date: Jun 2007
Posts: 7
Time spent in forums: 2 h 50 m 45 sec
Reputation Power: 0
|
|
|
Count
I have some experence in dBase. But not a clue in SQL.
I have a dbase IV file that I need to do a count on.
There is some code I found in the program, unrelated to what I'm doing.
SELECT * FROM [PER_DIL] where ([SC] = "64-006")
I show it only to give an idea as to the program (As if that might help). Becouse I don't even know if the code is Microsoft.
I'm trying to a count on how many times a value occures in a file. The field is "SC". There is many different values in the field. I want to know how many times each value occres. I have an empty field to hold the value. The "SC" is a char field. The data base is "per_date".
Bob
|