Hi all,

1. Here is my data:

Field 1          Field 2            Field 3
Stop Type.....1st Officer......2nd Officer
Subject..........#1.......................*null
Traffic...........#2......................#1
Traffic...........#3......................#4
Subject..........#4.......................*null

2. I created two crosstabs of the data:

Field 2
1st Officer....Subject......Traffic
#1....................1................0
#2....................0................1
#3....................0................1
#4....................1................0

and...

Field 3
2nd Officer....Subject......Traffic
#1....................0................1
#2....................0................0
#3....................0................0
#4....................0................1


3. How do I sum or "merge" the data from the two crosstabs to create this
(I want this result)

Field 2 and 3
Officer.........Subject........Traffic
#1....................1................1
#2....................0................1
#3....................0................1
#4....................1................1

Edited by dspolans - 29 Dec 2011 at 4:21pm

Thanks for the reply. Wouldn't that result with:

Officer.........Subject........Traffic
#1....................1................1
#1 #2...............0................1
#3....................0................1
#4....................1................1
#3 #4...............1................0