Best way to compare two counts...

Rickstar321

New member
Local time
Today, 12:42
Joined
Nov 27, 2012
Messages
5
I've been through a basic class on Access and this will be my first project completed... I hope...

We will have 2 teams counting the same material...

What will be the best way to set this up so that I can compare the 2 counts?...

What must match is location, part number, quantity, and various value added items... ie coating, weld on parts, etc

Would it be best to use tags 1-4000 for first team... 4000-8000 for second count team? or create 2 identical tables, one for each team?

I want to build a variance report that shows all non-matching items.

I've built a start up... tag table... count team table... but stuck at how to best make the comparison of the two counts.

You guys are awesome... just saying... :-)
 
You don't set up 2 tables to hold identical data, you create a field to differentiate it. What does your table look like so far? Field names? Most likely you will just add a field called TeamNo which will hold 1 or 2.
 
Wow... you just made me realize how short sited I was being about this! lol... Thanks!
 

Users who are viewing this thread

Back
Top Bottom