how to count instances

M

Maxine

hi there I have a report of about 10,000 training activities and I need to
group/count them by individual i.e. i need to know how many times each person
took training. i am completely new to access - any idea how to do this??
 
S

storrboy

Creat a new query, add the required table(s) and fields. From the View
menu while in design mode choose Totals. This will add a line in the
lower portion called Totals. In each field that a grouping is needed
mke sure the Totals line says Group y for that field. In the field you
wish to count choose Count.

You need to think this through first. Each grouping field will add
more record lines as more unique detail may be presented. The fewer
the groupings, the more summary like the results become.
 
T

Todos Menos [MSFT]

sorry, kid

Access won't support 10,000 records

you should move to SQL Server
Access Data Projects are a great solution
 
T

Tony Toews [MVP]

A a r o n K e m p f wrote:

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.
sorry, kid

Access won't support 10,000 records

Wrong. Access will support at least 100 million records.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Todos Menos [MSFT]

Note that Tony Toews is a MDB _WUSS_ and should not be trusted for
anything.

It's like going to ask a 1st grader for financial advice


ADP uber alles!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top