Re: Time Field: Sorts incorrectly

From: Roger Carlson (NO-Rog3erc-SPAM_at_hotmail.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 13:50:20 -0400

I am not seeing this behavior in my test file. Are you using the Format()
function in your query? That will convert you time to a string value and
will show the kind of behavior you describe. 

-- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org
"Iram" <Iram@discussions.microsoft.com> wrote in message
news:31930B00-2D77-48D3-8875-645987F5734C@microsoft.com...
> Hello,
> I have created a table with a field called "Time". The Format is Medium
Time with an Input Mask of 09:00\ >LL;0;_
>
>
> I have created the following records in the table:
>
> 8:00:00 AM
> 8:30:00 AM
> 9:30:00 AM
> 10:00:00 AM
> 10:30:00 AM
> 11:00:00 AM
> 11:30:00 AM
> 12:00:00 PM
> 12:30:00 PM
> 1:00:00 PM
> 1:30:00 PM
> 2:00:00 PM
> 2:30:00 PM
> 3:00:00 PM
> 3:30:00 PM
> 4:00:00 PM
> 4:30:00 PM
> 5:00:00 PM
>
> Once I sort these times in a query or report they sort as:
>
> 1:00:00 PM
> 1:30:00 PM
> 10:00:00 AM
> 10:30:00 AM
> 11:00:00 AM
> 11:30:00 AM
> and so on....
>
> Even the Reports that sort by time don't sort correctly.
> This table acts as a Combo Box table/query field in a master table.
>
> Your help is greatly appreciated,
> Iram/mcp
>

Relevant Pages

  • Re: Rowsource of unbound object
    ... That is because the Format function returns a string. ... This works in a query, not sure how it will work for your Gantt Chart ... The report events are Open, Close, Activate, Deactivate, No Data, ...
    (microsoft.public.access.modulesdaovba)
  • Re: step through table and select data for reporting values
    ... I set the dates to "mmdd" vs the output the query is currenly giving me ... I've tried to include the format in the expression itself but this ... I have a report with an unlimited amount or rows. ... > 3) Add the Primary key field and the "Jobs" table foreign key to the grid. ...
    (microsoft.public.access.modulesdaovba)
  • Re: sort in report
    ... "fredg" wrote: ... date on my report. ... fields I would like to sort on in a report: ... so the format is irrelevant). ...
    (microsoft.public.access.gettingstarted)
  • Re: Four Report Problems
    ... I changed to the query like I thought I had, ... I just typed the names of the banks in the Lookup tab. ... Field List into the Report. ... Don't use an expression to format a value. ...
    (microsoft.public.access.reports)
  • RE: Sorting in Query and Report involving look up combo box
    ... That is the problem with lookup fields. ... query and the report and the best way to do that is having the look up field. ... I have the report grouped by Artist Name and then Sorted by Style Number ... And, as I said before, Reports ignore the sort order of a query. ...
    (microsoft.public.access.reports)