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?
See attached image.
Any ideas on how to sove this?