J
Joe Williams
I would like to know how I can divide two numbers and have access give me
the remainder instead of a decimal.
I am making a label program for our products and I am looking to generate a
certain quantity of labels. In our Product ID table we have the number of
pcs per box stored as a field.
What I need to to is to tell the system we are shipping 120 pcs and it will
generate 2 labels for 50 pcs and 1 label for 20 pcs. If I divide in access I
get 2.4. What I would like is 2 with remainder of 50. how can I convert or
is there another way to get that number?
I have the printing and the number of labels figured out but I do not know
how to do the division and get the remainder of 20 to print the partial
label.
Can anyone assist? Thanks
Joe
the remainder instead of a decimal.
I am making a label program for our products and I am looking to generate a
certain quantity of labels. In our Product ID table we have the number of
pcs per box stored as a field.
What I need to to is to tell the system we are shipping 120 pcs and it will
generate 2 labels for 50 pcs and 1 label for 20 pcs. If I divide in access I
get 2.4. What I would like is 2 with remainder of 50. how can I convert or
is there another way to get that number?
I have the printing and the number of labels figured out but I do not know
how to do the division and get the remainder of 20 to print the partial
label.
Can anyone assist? Thanks
Joe