Re: Help Needed With Format Of Query Expression

On Apr 30, 1:37 pm, "KC-Mass" <connearneyATcomcastDOTnet> wrote:
Add two expressions to the query.  One is the year and the other is the week
(in that order).
Sort on those and just display your "Week: Format([TxtDate],"ww yy",4)".

Regards

Kevin C

Thanks for the reply but I tried that. The Week and Year fields still
sort as Text fields, not Number fields. Even if they did sort as
Number fields the whole thing still falls over when the query spans
several years.
.