I cannot figure out for the life of me to get this to work, I have multiple tables and all tables have the same fields, Nomenclature, Name, NSN, Platoon, ECT. Under Platoon in each table i have 4 diff platoons Ops, 1st, 2nd, 3rd. I want to pull info from all tables based off of the platoon. This is for a weapons system database. I have a table for each weapon system that gives the info then it is sorted by the platoon field. I need the info from all the fields just sorted by the relevant platoon. So I have an m16 table with all fields listed above and an m4 table with all fields listed above. I need to figure out how to combine all the tables then make it show the items for a single Platoon from all the tables so i can make a report.
I am so frustrated right now i probably sound retarded but im getting sick of trial and error so this is my last resort.