Jobs

Computers

Healp About MS Access 2000

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

Husnain55 Thurs 27/03/08 17:51

<< Previous

Next >>

Subscribe to question

Post an Answer

kujawski
Wed 16/04/08
12:23

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

Post an Answer

Submit the above question and answers

add to del.icio.us	add to digg	add to furl
add to reddit	add to Technorati	add to Blinklist
add to StumbleUpon	add to squidoo	add to ma.gnolia
add to Cocomment	add to Netscape	add to Fark