JKwan
09-27-2017, 07:44 PM
I am really novice with Access and from what I google, all I found were how to create Master Detail Forms, which I don't think is what I wanted. I needed a table because I need to pull this info into Spotfire to do analysis. My scenario is that I have 2 tables which summarized to an InjuryType and BodyHarmed tables. To make it simple InjuryType contains CaseNumber and InjuryType as fields and BodyHarmed has CaseNumber and TreamentType
InjuryType
CaseNumber - 1
InjuryType - First Aid
BodyHarmed
CaseNumber - 1
TreatmentType - Head
CaseNumber - 1
TreatmentType - Leg
From the perspective when I create a query, I want to get:
How many First Aid - 1
How many Treatment Types - 2
However, when I structure my query, I get 2 First Aid, which the join gives me.... How do I structure my tables to do the above? Thanks.
InjuryType
CaseNumber - 1
InjuryType - First Aid
BodyHarmed
CaseNumber - 1
TreatmentType - Head
CaseNumber - 1
TreatmentType - Leg
From the perspective when I create a query, I want to get:
How many First Aid - 1
How many Treatment Types - 2
However, when I structure my query, I get 2 First Aid, which the join gives me.... How do I structure my tables to do the above? Thanks.