Good morning and Lo All,
I have finally had to graduate into Access/SQL after the sizes of files I am working with are upwards of over 100mbs, in one file it's nearly half a gig. Excel craps out the CPU, thus I am building an Access DB while our IT/CFO determine a BI platform to sign up with (Looker, Tableau).
I tried building an Access DB over the weekend but when was attempting some queries from multiple tables my values were multiplied by the count of relevant records from other tables. After some more researching I believed the issue was data normalization. I have attached an image of my current DB diagram w/ relationship and was hoping for some input (btw, I am already renaming the fields w/out spaces).
Thank you all very much for the input.
kondukt