How do I left justify a date
in [Queries]
|
From: DavidSherwood on 15 Jan 2010 18:21 If I convert the date to string in a query, it won't sort properly
From: Bob Barrows on 15 Jan 2010 18:26 DavidSherwood wrote: > If I convert the date to string in a query, it won't sort properly Your problem stems from using the Query Builder to display results to users. That is not what the tool was designed for. You should be displaying query results to the user in a report or form where you have complete control over how the data is formatted for display. The Query B uilder is for designing and testing queries - it is n ot intended to be an enduser interface. -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
From: DavidSherwood on 15 Jan 2010 21:29 Reports are static paper like results. Queries let the user inter-react: filter, sort re-arrange columns. Of course queries are for end users.
From: Bob Barrows on 15 Jan 2010 23:23 DavidSherwood wrote: > Reports are static paper like results. Queries let the user > inter-react: filter, sort re-arrange columns. Of course queries are > for end users. You definitely have the wrong idea about reports. But carry on. -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
From: KARL DEWEY on 16 Jan 2010 23:24
Use the string for viewing and the actual date for sorting but uncheck the 'Show' box. -- Build a little, test a little. "DavidSherwood" wrote: > If I convert the date to string in a query, it won't sort properly |