Access Table /Query

[cop4u2nite]

Hi,

I'm setting up a database for a local P.D. I have created a table called Arrest table. Within the table I have multiple columns. The columns are titled: Charge, Inmate Name, Arresting Ofcr, Id, Backup Officer, Bkup ID, Date, Booking number and Reporting District.

Ok, heres the deal. What I'm trying to do is run a query where I can see how many arrest a certain ofcr has made.

How many drug arrest we had during a certain time period. How many arrest were made during a certain time period for Burglary.
How many times did a Arresting ofcr have a backup officer assist with an arrest.

The content within the column "Charge" stores the law code violation number. "Officer" stores last names, "Booking number" stores a number, "Date" is numerical as well. "Inmate" is name.

Can someone help?

Thanks...JG...Los Angeles Police

 

[sfreeman]

I think you may have a normalization issue. I'd probably break down this table into several other tables, ie tblOfficers, tblCharges, etc.

Sam_F
"90% of the problem is asking the right question.