hi there,

i need to create a field that has this format
[YYWWMMwwxxxx],YY=year, WW=workweek(assume 52 per year) ,
MM= machine , ww=winders , xxxx=running numbers

total machines=16
winders per machine = 6

this field is used as a unique id to identify when product(reels)that being produce (year & work week),which machine,winders that produces the reels and the running number indicates the total reels produced in a week and will be reset every week.

example : running number = 0001=1 reel has been produced.
Is it possible I create a field containing all this so that in future easier for me to identify the particular product referring to this unique id?and I must store this id in my database. I am beginner so please be kind.

Thanks alot


tasha

__________________
tasha

I think you will find it useful to have the data you mention in separate fields and make another based on the concatenation (adding together) of those fields. NB. everything needs to be text, so you may need to convert the field contents in your expression.

QUERY EXPRESSION
MyField: [Categories]![Project Number] & [Categories]![Board] & [Categories]![Business Unit]

SQL
SELECT [Categories]![Project Number] & [Categories]![Board] & [Categories]![Business Unit] AS MyField
FROM Categories;


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

thanks brian, i have a a table that stores that particular information that i mentioned earlier, can i automatically create a new field from other fields within the same table?

i.e
date
machine
winder

tasha

thanks brian, i have a a table that stores that particular information that i mentioned earlier, can i automatically create a new field from other fields within the same table and how do i convert the contents in expression?

i.e
1.date 2.machine 3.winder 4.running number

5.dt_mchn_wndr_runninnum (new field)

2.The running numbers will be increased by 1 everytime the user choose new record and will reset once in a week. how can i do that?

sorry i am very new in vba.thanks alot.




tasha