Report with summary data

[markh719]

sorry if this is a bit remedial...

I have an excel report that i pull monthly from an internal database I would like to create an access database from that report that will show me the number of referrals by source and/or by agency.

the headers in the report are below. This report is broken down by patient name and each person admitted by date. I want to see how many times the source name and/or agency has referred and keep a running tally through the year. I have never built a database or used access, please help... and I need to add a few fields adress, city, state, zip, phone, email, marketer.

so for instance MEMO comes up in this report under source name 752 times in this report, I want the database to say MEMO RCDCOUNT 752, and when I upload the report next month I want it to add any more RDCOUNT to the existing number.

PATIENT ADMIT DATE

HSV

ADMISSION TIME

PATIENT #

PATIENT NAME

PATIENT AGE

INTAKE BY

F/C

INSURANCE

SOURCE NAME

AGENCY NAME

RCDCOUNT

[June7]

Are you using report Sorting & Grouping features with aggregate calcs in header/footer sections?