Solved Format Double Digit Week Number (1 Viewer)

Uncle Ned

Registered User.
Local time
Today, 12:43
Joined
Sep 26, 2019
Messages
45
Hi Folks, I've put together a simple planning query that checks the number of times that different sized moulds are required each week over a period of time. The problem is that formating the week number it only uses a single digit for week numbers between wk 1 and wk 9. Then sorting by week number solts these weeks out of sequence.

See attached image.

Any ideas on how to sove this?
 

Attachments

  • MouldQuery Date Format.jpg
    MouldQuery Date Format.jpg
    159.3 KB · Views: 87

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:43
Joined
May 7, 2009
Messages
19,175
Expr1: Year([PlannedShipDate]) & "/" & Format(DatePart("ww",[PlannedShipDate]),"00")
 

Uncle Ned

Registered User.
Local time
Today, 12:43
Joined
Sep 26, 2019
Messages
45
Brilliant, thanks for your help
 

Users who are viewing this thread

Top Bottom