Access 2002 SP3

Hi forum, forgive me for asking a question that have may already be coverd, but I have hunted for a specific answer - but no luck.

I have created a contact management database and what I would like to be able to do it run a report that calcualte and shows:

A specific number of appointments set per date, per consultant.

Ie:

29/07/10
Karen 2
Chris 3

Total 5

30/07/10
Karen 2
Phil 4

Total 6

The date is stored under a Nextcalldate function and consultant under record owner.

I can produce a report that shows all of the apppointments in detail and when it was booked, who booked it and when it is for - but want to produce a snap shot per day as an overview.

So essentially I guess I need to interrigate the database to work out on which date, what consultant has a record and total their records and give a total for all consultants.

Phew.

Please be gentle as im a newbie to Access and learning on the hop, so please be as layman as possible.

thanks to all guru's

You want what's called a Totals query. Start a query on your table, selecting the date field and the consultant field twice. On the toolbar you'll see an icon that looks like a Greek "E". Click on that and an extra line will have appeared in your query design view. Each of the 3 fields above will say "Group By". Change the second consultant field to "Count" and run the query.