I figured out how to upload this for viewing. This is the information that I have in my database. I need to do reports like:
equipment in space name
cables in space name
cables by equipment
equipment by type of space
cables by type of space
My biggest problem is trying to get Nomenclature A and Nomenclature B queried correctly. Each piece of equipment has a Nomenclature. Nomenclature A and Nomenclature B come from one list and will never be identical. How do I query it to do something like this:
List all Nomenclature A, list Nomenclature B IF it does NOT = Nomenclature B?
I don't understand why you have two nomenclatures, so I'm not sure the best way to fix that. With what you currently have, you could use something like this:
SELECT [NOMENCLATURE A], iif(NOMENCLATURE B] <> [NOMENCLATURE A], [NOMENCLATURE B], "value if both nomenclatures are equal"
FROM tblCABLES INNER JOIN tblEQUIPMENT ON tblCABLES.[NOMENCLATURE A] = tblEQUIPMENT.NOMENCLATURE
INNER JOIN tblEQUIPMENT_1 ON tblEQUIPMENT_1.NOMENCLATURE = tblCABLES.[NOMENCLATURE B]
I would also advise you to rename your fields to something short with no spaces, it makes life easier later. That's more of a personal preference/best practice thing though, not like it's detrimental to your db.