Re: Producing Labels
From: tina (nospam_at_address.com)
Date: 12/28/04
- Next message: Marshall Barton: "Re: How to arrange values in combo box"
- Previous message: Allan Murphy: "Re: Runtime error 2501"
- In reply to: Joe Williams: "Producing Labels"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 28 Dec 2004 22:28:08 GMT
to get the remainder, try
120 mod 50
that will return 20.
hth
"Joe Williams" <JOE@ANYWHERE.com> wrote in message
news:OfW2DpS7EHA.3708@TK2MSFTNGP14.phx.gbl...
> 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
>
>
- Next message: Marshall Barton: "Re: How to arrange values in combo box"
- Previous message: Allan Murphy: "Re: Runtime error 2501"
- In reply to: Joe Williams: "Producing Labels"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
