Count Field Values.

[Cined]

Hello,



I have to create a simple report, but have no clue how to do it.

Basically I need to have one column in the Report containing different Vehicle types, which are values in a `Vehicle type` field (this part I can manage). The next column in the report needs to count how many records have that car type as it's value.

The report should look something like this:

Vehicle type | Number
---------------------------------
Van | 5

...


How would I achieve this?


Thanks.

[Rixxe]

Firstly you would need a query like this, to count the number of vans/cars etc etc

select a.vehicle,COUNT(a.vehicle)as number
from TBLCarsNStuff as a
group by a.vehicle

And then google something like below to find out how to put it all into a report.
I guess if you want it to update on a regular basis you might need to use some VBA code. (Not sure about that)

http://www.ehow.com/how_7350951_add-...gn-access.html

[ajetrumpet]

Rachel,

I would suggest putting those eHow pages in your signature. You're always attaching them to the bottom of your posts, and I don't think anyone understands why you do it. I didn't for a while...

Alot of them are a bit on the simple side too, which sometimes doesn't help people here. Just trying to help ya out! (especially if you are posting these responses remotely!)

Firstly you would need a query like this, to count the number of vans/cars etc etc

select a.vehicle,COUNT(a.vehicle)as number
from TBLCarsNStuff as a
group by a.vehicle

And then google something like below to find out how to put it all into a report.
I guess if you want it to update on a regular basis you might need to use some VBA code. (Not sure about that)

http://www.ehow.com/how_7350951_add-...gn-access.html

[Rixxe]

Rachel,

I would suggest putting those eHow pages in your signature. You're always attaching them to the bottom of your posts, and I don't think anyone understands why you do it. I didn't for a while...

Alot of them are a bit on the simple side too, which sometimes doesn't help people here. Just trying to help ya out! (especially if you are posting these responses remotely!)

Derek,

I would suggest that perhaps you could troll some more if it pleases you...
I think adding a link to a site which describes a solution to a problem in a SIMPLE way isnt a bad idea. 'Sometimes', so SOME people will find it useful, and some wont...

Also your observation's are poor at best, it just so happens i might have used a similar link in a previous post (GOD FORBID!!!!!!!!!!!! Sense the sarcasm?)

Next time, i agree, ill link a page which the OP will not understand, which will not help them with the required problem, but because its REALLY complex it's 'useful' right?

Just trying to help ya out!