Counting with sql in delphi and ms access database
Posted on 2004-10-08
I have a problem on counting with an query-component in delphi and an underlying ms access database.
My database is organized as follows:
Field1= date, Field2= Wagonnumber, Field3= Trainnumber, aso...
Now I want to count the different trains within a certain date.
But as I work with ms access 97, I get always some errors.
I tried the following:
select distinct field1, count(field3) from table group by field1, but that counts the wagonnumbers, because every wagonnumber has a trainnumber.
I hope I've made me clear, because I passed several hours with this problem and I can't manage it. Could so please give me a solution , so that I can count my trains.