Join up data rows

Hi guys,

I have previously benefitted significantly from help I received on this group after reaching out and I have another issue which I cannot fix immediately.

The problem:

I have multiple different incident numbers prescribed to the same event which is leading me to double count my data. What I want is to join the incident numbers together for the same event type.

The location of the event is sometimes similar or the same but not always
The date of the event is always the same
The classification of the event is normally the same or similar

So if I joined up all of those variables I would perhaps be able to do it.

Again any help is greatly appreciated.
Thanks in advance.
Kindest regards

James


Rugbynut (BOB member since 2017-01-08)