M
Marco
Hello. I building a little access database to insert pallets.
I have a problem here.
I need to insert pallets numbers in a table with quantities but I need that
my Insert query only insert pallet number that where not already insert or
that the Total value field is diferent than zero.
Imagine, that my production number 123 has the following pallet number and
quantities:
Pallet Quantity Total
10 100 0
11 150 0
12 150 75
and my production number 456 has the following pallets number:
Pallet Quantity
12 150
10 100
14 150
In this example I need only to insert this:
Pallet Quantity
12 75
14 150
is it possible to do this?
Thanks,
Marco
I have a problem here.
I need to insert pallets numbers in a table with quantities but I need that
my Insert query only insert pallet number that where not already insert or
that the Total value field is diferent than zero.
Imagine, that my production number 123 has the following pallet number and
quantities:
Pallet Quantity Total
10 100 0
11 150 0
12 150 75
and my production number 456 has the following pallets number:
Pallet Quantity
12 150
10 100
14 150
In this example I need only to insert this:
Pallet Quantity
12 75
14 150
is it possible to do this?
Thanks,
Marco