Hello All,
This is my first post here, so I will give a bit of background on myself. I am a Mechanical Engineer a few years out of college, and I am working for a small company that repairs Aero-derivative gas turbine parts. I am trying to design an Access database to store information and track each job that goes through our shop (each set of parts we repair).
I have a tiny bit of Access experience, and "a lot" of Excel/VBA experience. I designed one "database" for managing all of the calibrated tooling we have, but it uses Access, but was more of a VBA implementation. I did not have any relationships established, and used all VBA/SQL to enter data from forms into tables.
My Question:
If I run a query on 3 filled tables I get some results. But if I add a 4th table with zero records, I do not get any results.
Could someone please explain this to me, I am clearly missing something.
In some cases the 4th table will have data that should be pulled, but in other cases the 4th table will not have data.
See the attached picture for the example Query and associated Tables.
Thanks!
Nathan
This is my first post here, so I will give a bit of background on myself. I am a Mechanical Engineer a few years out of college, and I am working for a small company that repairs Aero-derivative gas turbine parts. I am trying to design an Access database to store information and track each job that goes through our shop (each set of parts we repair).
I have a tiny bit of Access experience, and "a lot" of Excel/VBA experience. I designed one "database" for managing all of the calibrated tooling we have, but it uses Access, but was more of a VBA implementation. I did not have any relationships established, and used all VBA/SQL to enter data from forms into tables.
My Question:
If I run a query on 3 filled tables I get some results. But if I add a 4th table with zero records, I do not get any results.
Could someone please explain this to me, I am clearly missing something.
In some cases the 4th table will have data that should be pulled, but in other cases the 4th table will not have data.
See the attached picture for the example Query and associated Tables.
Thanks!
Nathan