Daily Packing Number

[gbb0330]

Hi all

I need some advice.

the daily packing number will be used to match a box with its label.

the guys in the warehouse will get a list of items to pack. they will
find the item - put it in a box and click a button [packed] at this
point the daily packing packing number will be genrated. the packing
guy will write it on the box.

later the labels will be printed, for each box. andthe packing guy will
know which label goes where.

reuirement, the packing number must be easy to remeber, no more than 4
digits.
must be unique, and must start over every day or every week.

what is the best way to do this?
any ideas?

[Darryl Kerkeslager]

On 17 Feb 2005 13:58:19 -0800, gbb0330 <gb*****@gmail.com> wrote:

the daily packing number will be used to match a box with its label.

the guys in the warehouse will get a list of items to pack. they will
find the item - put it in a box and click a button [packed] at this
point the daily packing packing number will be genrated. the packing
guy will write it on the box.

later the labels will be printed, for each box. andthe packing guy will
know which label goes where.

reuirement, the packing number must be easy to remeber, no more than 4
digits.
must be unique, and must start over every day or every week.

what is the best way to do this?
any ideas?

A mix of two letters and two numbers would, IMHO, be easiest to remember,
if you can do that.
Darryl Kerkeslager

[PC Datasheet]

To start over every day ---

Me!PackingNum = IIF(DCcount("*","TblPacking","[PackedDate] = #" & Date() &
"#") = 0,1, _
DMax("[PackingNum]","TblPacking","[PackedDate] = #" & Date() & "#") +1
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"gbb0330" <gb*****@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

Hi all

I need some advice.

the daily packing number will be used to match a box with its label.

the guys in the warehouse will get a list of items to pack. they will
find the item - put it in a box and click a button [packed] at this
point the daily packing packing number will be genrated. the packing
guy will write it on the box.

later the labels will be printed, for each box. andthe packing guy will
know which label goes where.

reuirement, the packing number must be easy to remeber, no more than 4
digits.
must be unique, and must start over every day or every week.

what is the best way to do this?
any ideas?