I'm not sure what you expect of the proposed database.
I'm looking at your data and I note
Code:
SELECT DISTINCT BDPerfil.MicroorganismoGram_negativo
FROM BDPerfil
WHERE (((BDPerfil.MicroorganismoGram_negativo) Is Not Null));
You have 7 unique gram negative items
MicroorganismoGram_negativo |
Acinetobacter baumannii |
Citrobacter koseri |
Enterobacter aerogenes |
Escherichia coli |
Klebsiella pneumoniae |
Proteus vulgaris |
Pseudomonas aeruginosa |
and 4 Gram Positive
Code:
SELECT DISTINCT BDPerfil.MicroorganismoGram_Positivo
FROM BDPerfil
WHERE (((BDPerfil.MicroorganismoGram_Positivo) Is Not Null));
MicroorganismoGram_Positivo |
Enterococcus faecalis |
Staphylococcus aureus |
Staphylococcus epidermidis |
Staphylococcus lugdunensis |
and 7 unique sectors
Code:
SELECT DISTINCT BDPerfil.Setor
FROM BDPerfil
WHERE (((BDPerfil.Setor) Is Not Null));
Setor |
Alto risco |
UA |
UB |
UB4 |
UC |
UTI Materna |
UTINeo |
and 3 material types
Code:
SELECT distinct BDPerfil.Material
FROM BDPerfil
WHERE (((BDPerfil.Material) Is Not Null));
Material |
Ferida operatória Cesárea |
Ferida Operatória HTA |
Sangue |
Getting a report in the format you've shown may be a challenge, but you could get info onto a form if there was a specific or other question.'
It really depends on the requirements.
I can see various subjects involved (separate tables) but would need more info to establish relationships.