Search results for query: *

I'm trying to streamline some addresses. There is really only one major issue I have. A business address is entered one of two ways: 123 Main St @ (Supermarket Name) or (Supermarket Name) @ 123 Main St. This ruins my statistics if I want to see which address has the most activity because...

I am trying to relate two tables. One table is incidents and the other table is offense. I'm trying to query for burglaries in a city but the tables don't appear to be linking correctly. When I link certain fields such as case number it state indeterminent (one is incident case number and the...

I have a cross tab report listing crime types. I would like to sort this report in descending order by the count of crimes - highest type of crime type to lowest. I only seem to be able to sort in alphabetical order. For example: Burglary 45 Assault 40 Larceny 20 etc. Secondly what formula...

Okay, I have one more problem. I have two seperate reports - one lists the name of the people arrested by a particular officer. The second is a crosstab report listing all of the officers and a count of their arrests. The number of felony arrests are higher on the crosstab report than on the...

aHH yes, and that worked - I now have a more accurate count of arrested subjects - but I still need to figure out how to have seperate counts for those arrested for felonies. Thanks

Actually that is my other problem. The are times when one person is arrested for several different charges regarding one incident. In that case I want it to count as just one arrest. On the other hand if the person was arrested two or more times by the same officer regarding different...

I have a report showing a list of arrested subjects by officer. I have all of names of people arrested for felony arrests in red. Now I want to have a total at the bottom of the report - a count for felony arrests and a count for misd. arrests. In other words, all of the names in red to have...

It's working great except that the first address on the report and the last address on the report are highlighted even though neither address is duplcated. Any idea why or how to correct this? Thanks again for all of your help!

Previously I asked how to highlight duplicates - I received a good response stating to put the following formula in the format field (border) section: if previous ({Incident.Address}) = {Incident.Address} then cryellow else crwhite. However this only highlights one of the addresses (if there...

I have a report showing burglary locations within a city. I would like and duplicate addresses to be highlighted in some way so that we can easily see when an address is repeatedly burglarized. I can't figure out how to write the formula. Thanks

I have a report that lists crimes occuring on different addresses within our city. I would like to take out the street number from the address field and just show the street names only. What would the formula look like? Thanks

I am trying to do a report on percentage changes from month to month regarding crime rates. My report is grouped by month then by crime type: June Count Percentage Change Aggravated assaults 200 Burglary 439 July Aggravated assaults...