Re: report info not in order

Tech-Archive recommends: Speed Up your PC by fixing your registry

anonymous_at_discussions.microsoft.com
Date: 08/10/04 

Date: Tue, 10 Aug 2004 15:48:31 -0700

the day ofthe week were specificly entered the their
natural order in the day table. next I checked the query
and they appear in instead of Sun through Sat. they run
Mon through Sun. the report runs off of the query however
the days just don't make sence. they are in no particular
order. in the query is there any way to specify that I
wan't the days to start and end were I want them to not
the computer making up the order and not excluding any
days?
>-----Original Message-----
><elisabethm@acwanet.com> wrote:
>
>>I am have a problem with my report. the order that i
>>imputed the information in the cells is not the order
that
>>the information is being displayed in the report. ifact,
>>the information does not seem to be in any order. it is
>>the days of the week. I imputed from Sun. through Sat.
but
>>the report gives me random days and its not even
>>alphabetical. what do I do?
>
>
>Note 1. The records in a relational database table are
>unordered. You must have a field in the table that can be
>used to sort the records in the way that you want.
>
>Note 2. In all but simple cases, the sorting of a report
>needs to be specified in the report's Sorting and Grouping
>window (View menu).
>
>Incorporate those requirements into your thinking and, is
>you need more help, post back with more details about the
>type and values of the field you want to sort and how you
>specified the sort order.
>
>--
>Marsh
>MVP [MS Access]
>.
>

Relevant Pages

  • Re: Report parameters
    ... I open the report, frmSpecifyRecord shows up, I ... Another field in the query is SessionDate. ... Between And as the criteria, ... Now I want to specify the date range on frmSpecifyRecord, ...
    (microsoft.public.access.reports)
  • RE: Multiple parameter query - need Help!!!
    ... I have a form where user specifies the fields for the report via checking ... I am trying to create a query that would use all those ... specify employee name, company, job code, department, and other criteria. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Parameters to OpenReport
    ... I tried the following code to set paramter query but report still ... ADO Command object can detect the parameter of the subquery and set its ... Can I specify a value of a named parameter belonging ...
    (microsoft.public.access.queries)
  • Re: How do you ask for input from the user to filter out just those r.
    ... In the query you need to specify the ... if you have a "date created" field on your report and you want ... In the criteria field youd put something like... ...
    (microsoft.public.access.tablesdbdesign)
  • Re: report info not in order
    ... >Mon through Sun. the report runs off of the query however ... There is no such thing as a natural order in a table. ...
    (microsoft.public.access.reports)