N
Nasko
Hola,
I have the next problem.
In one table I have a productname and the number of cartons that fit on a
pallet
Products.ProductID and Products.CartonsPerPallet
For example
ProductID CartonsPerPallet
12345 20
In another table I have a shipping order with a number of requested cartons.
ShippingOrder.line, ShippingOrder.ProductID, ShippingOrder.Cartons
Line productID Cartons
1 1234 44
Now I want in another table the number of full pallets, which should be 2
....rounddown(44/20)... and the number of loose cartons ...44%20...
Can I put this in one querry,
Thanks,
I have the next problem.
In one table I have a productname and the number of cartons that fit on a
pallet
Products.ProductID and Products.CartonsPerPallet
For example
ProductID CartonsPerPallet
12345 20
In another table I have a shipping order with a number of requested cartons.
ShippingOrder.line, ShippingOrder.ProductID, ShippingOrder.Cartons
Line productID Cartons
1 1234 44
Now I want in another table the number of full pallets, which should be 2
....rounddown(44/20)... and the number of loose cartons ...44%20...
Can I put this in one querry,
Thanks,