weeknumber

[referee]

hi all,

in a query a wont do the following:
in a field i have a weeknumber
1
2
3
.
52
etc
now fot the numbers between 1 and 9 i want to place an expression
thats change this numbers to 01, 02... 09

can someone help me with that expression for my query


thanks

 

[kherm]

Not elegant, but it might work...

This might work:

week2: IIf([weekfield]<10,"0" & ([weekfield]),[weekfield])

Ken

 

[referee]

THANKS

this is what i wanted


greetings

 

[namliam]

Its much easier to use format(weeknr,"00") and/or to use a function like CInt to convert the returned string to a real number, then if you sort it... It will be the right order....

Regards