Healp About MS Access 2000

[Husnain55]

I want to make a data base for transporation. I have made 04 column in a table. 1-VAN # , 2- Shift, 3- Route and total.
I wish that when I will feed data in first three column for example
VAN # Shift Route
50 A CITY
50 A CITY
100 B CITY

I WISH THAT IN FOURTH COLUMN ANS MUST COME
FOR FIRST TWO LINE 2
AND
FOR THIRD LINE 1
Actually i want count data if van # Shift and Route have same data it must count the rows.
I hope Sir you will healp me in this matter
Thanks

[kujawski]

you need to create a query that reads:

select [van #],shift,route,count(*)
from my table
group by [van #],shift,route

which will output :
Van# shift Route count
50 A City 2
100 B City 1

from the data given