Recent content by LiamKJ

Same parts, but stored in different locations. Some restraints on how I would structure it, as I'm fed the data as a list of missing parts from multiple locations, and am trying to identify what isn't present at each location, and for how long it has been missing.

I've attached an excel file with a sample dataset, and showing my three (now four!) tables. I've essentially loaded my dataset into access, and have set up queries (first a regular, then also showing in a crosstab) for tables 1 and 2, but am super stuck writing the queries for 3 & 4. I think...

Cheers! Absolutely, it'll be tomorrow by the time I can replicate with some dummy data, but I'd appreciate it if you could take a look once I've thrown some up!

Hello fellow Access nerds! After many years, I've finally made the post I typically google for. I have a dataset that regularly reports which products are absent on a warehouse stockcheck, which I am trying to use to analyse when stock is or isn’t available. I’m essentially trying to identify...