Re: Time Field: Sorts incorrectly

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Iram (Iram_at_discussions.microsoft.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 12:46:01 -0700

All taken care of.

I set the Master table, Time field to Date/Time Medium Time. Then I set the forms to query the Time Table to pull the time range and insert it into the table.

Iram/mcp

"Roger Carlson" wrote:

> 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: error pulling data from query using a command button on a form
    ... You can't refer to fields in queries that way. ... What is DET1PERSONNEL1 Query? ... > 'I am attempting to pull data from a column in a query. ... > Private Sub UpDateSingleRecord_Click ...
    (microsoft.public.access.forms)
  • Re: Access Table Sorting/Query Last Function
    ... The table is set up as a datasheet. ... of the Lastin your totals query. ... I've been designing a database that basically works off two tables. ... I've done this so that I can pull the last entered ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access Table Sorting/Query Last Function
    ... I've put in a number of test entries to ensure it works, ... of the Lastin your totals query. ... I've been designing a database that basically works off two tables. ... I've done this so that I can pull the last entered ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Link Pulldown to Query
    ... I want to use a pull down menu to select data that will then be used to ... >> results of the query. ... >> reading the selection data from a Access table. ...
    (microsoft.public.access.gettingstarted)
  • Re: Query records with single Dates Automatically
    ... Here is the code for the Out of Town Report: ... both queries pull from the same table. ... -- Two Tables Attendees and Visits ... Please copy and post the SQL of your query. ...
    (microsoft.public.access.queries)