report how many catagories in a field

[Guest]

I am creating a database which i have entered the same name numerious times
in one column, now i want to create a report tellign me how many times each
name appears, eg i have in one column;
cat
dog
cat
cat
dog
and i want a report that will tell me i have cat=3 and dog=2, im only
slightly skilled in access so if i need ot type in some code or something to
create a rule or wat eva, plz specify what to open n where to type it if wat
i need is possible.

 

[Joseph Meehan]

I am creating a database which i have entered the same name numerious
times in one column, now i want to create a report tellign me how
many times each name appears, eg i have in one column;
cat
dog
cat
cat
dog
and i want a report that will tell me i have cat=3 and dog=2, im only
slightly skilled in access so if i need ot type in some code or
something to create a rule or wat eva, plz specify what to open n
where to type it if wat i need is possible.

One quick way is to make a query with two of that field (call it a field
not a column )

Click on the Sum (Sigma - M on it's side) button and leave the first one
group by and make the second one count (click on the "group by" and you can
choose count)

Use that for your report if you like or base a report on it. You can
also do it totally in the report but that is harder to tell you how to do
it.

 

[Jamie Collins]

One quick way is to make a query with two of that field (call it a field
not a column )

Great, a lesson in semantics from someone who uses such grammar as
"make a query with two of that field".

At the .mdb file level, it is a field (no one in this group is
interested in this level). At the database logical/engine level, it is
a column. At the cursor or recordset level (e.g. in a report), it is
usually a field.

Take a look at the ADO model (go on, force yourself). The Table object
has a Columns collection property. The Recordset object has a Fields
collection property.

The OP has clearly referred to the database level and I think you have
too. The correct term, then, is a column.

Here's a tip: if the customer uses a term which is approximately
correct, be nice and use that term back to them. If you set out to
correct them, first ensure you know the correct contextual term.

At least you have ceased asserting that in Ireland they say 'Math'.

 

[Guest]

Thanks 4 t attempot 2 help, but still a lil confused, however i kept
fiddleing trying 2 get wat i wanted n discoverd that if i make a chart using
the field/column that i want the results for i can then just change it to
become a PivotTable n that gives me wati need. thanks again