Help Needed With Format Of Query Expression
- From: Wayne <cqdigital@xxxxxxxxxxxxxxx>
- Date: Tue, 29 Apr 2008 20:01:18 -0700 (PDT)
I'm using the following expression in the query grid to show the Month
and Year of the date field "TxtDate":
Week: Format([TxtDate],"ww yy",4)
I am grouping the results on this field.
Is there a different way that it can be formatted so that when I sort
the field it will sort by Week and Year e.g.
01 07
02 07
03 07
At the moment it is sorting as a text field:
01 07
10 07
11 07
I can't simply sort by the "TxtDate" field because it isn't part of an
aggregate function and if I Group on TxtDate or use Min or Max the
query gives undesired results.
.
- Follow-Ups:
- Re: Help Needed With Format Of Query Expression
- From: KC-Mass
- Re: Help Needed With Format Of Query Expression
- Prev by Date: Re: Emailing with Access
- Next by Date: Re: Union Query Help File Interpretation
- Previous by thread: Popup/context menus not showing in modal forms
- Next by thread: Re: Help Needed With Format Of Query Expression
- Index(es):
Relevant Pages
|