Skip to Content
0
Former Member
Jan 03, 2008 at 05:47 PM

Cops and Guns

32 Views

Post Author: heme3

CA Forum: Formula

A Chicago Cop here, trying to learn all this tech stuff.

I have a C.R. that pulls data regarding all firearms recovered in the city by our officers.

There's 2 numeric fields for each cop: "Unit Assigned" and "Unit Detailed". The data is always 3-digit for both fields and looks like "001, 015, 253, 040".

So the report basically does this right now: "Inventory #12345, Smith and Wesson Revolver, Officer Smith - Unit Assigned: 001, Unit Detailed: 253"

I'm trying to make a formula for a cross-tab or chart that will sort out the officer's unit of assignment. Should be easy, but I ain't gettin' it. What I need it to do is this:

If "Unit Assigned" has a number in it, and "Unit Detailed" is null, then use the value in "Unit Assigned"

If "Unit Assigned" has a number in it, and "Unit Detailed" has a number in it, then use the value in "Unit Detailed"

(the "Unit Assigned" field is never null)

:o)

George

george.hemesath@chicagoplice.org