Search results

Hi all, With the help of some of the people here I was able to create a query that selects records from one table that have several fields which don't match with another table. The end-game with this query is to have it delete the records in table 1 that don't match records in table 2. The...

Hi all, I need help constructing a find unmatched query. I don't really know what I'm doing with SQL and I think that I can only take things so far with query design view. I have two tables. T_Productions and ProPro (see attached). In Access query design, I can only specify one matching...

Hi everyone, Long time lurker of your site. Seems like everyone is really helpful here. I am having trouble figuring out how to design a database which will allow me to track a raw material lot number through a number of productions until it reaches the final product. I then need to be able to...