heres what i want to do, i want to make a form that lets you put in a date then a part number and a inspection number and a total parts that are made of that part number
A ................B..............C................D
Date..............Part#.......inspection.....part #
11/24/05........lm4564.....902a1..........45
then i want to have a list of part numbers and inspection#
A.................B
lm4564......902a1
lm3745......90222
lm2354......912a1
now i want another form that you can type in a date and it will go down the hole first form find the dates that matches the date you typed in and then if the part# and the inspection number matches up then it will add all the total parts up for that date
thxs
A ................B..............C................D
Date..............Part#.......inspection.....part #
11/24/05........lm4564.....902a1..........45
then i want to have a list of part numbers and inspection#
A.................B
lm4564......902a1
lm3745......90222
lm2354......912a1
now i want another form that you can type in a date and it will go down the hole first form find the dates that matches the date you typed in and then if the part# and the inspection number matches up then it will add all the total parts up for that date
thxs