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...
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...
