report info not in order

G

Guest

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?
 
F

fredg

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?
Click to expand...

To sort records in a report, you must use the Report's Sorting and
Grouping dialog.
In Report Design View, click on View + Sorting and Grouping.
 
M

Marshall Barton

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?
Click to expand...


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.
 
G

Guest

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?
 
M

Marshall Barton

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?
Click to expand...

There is no such thing as a natural order in a table.

Almost always, sorting the query for a report is a waste of
time.

What type of field (in the table) is the day of the week?
Date/Time? Integer? or Text?

What are some sample values for day of the week?
 
G

Guest

what i ment by natural order was the days of the week.

I created a teble called days and 1 field in that table
containing the days of the week each with its own ID#. In
conference table days is a look-table with a drop down
list of the days. S M T W Th F S is the order in which I
entered the info. In the conference query day is one of
the table which I used. In design view you can see the
tables years, season, destination, hotel, day , blocked
and so on. In the criteria row, I indicated 1995 for
years, spring for season, and so on. the days I did only
indecated a criteria when I only wnated a day to appear in
the report. this is my problem: when I let all days
appear, thay are not in the order in which I entered them
in the table. when I am creating the report using the
wizard I have a choice to add another grouping (days) or
go to the screen and and sort. If I sort It will come out
in alphabetical order and I don't want that. If I group
before that I can't sort the days table and the finished
product comes out all messed up. the days are in no
particular order as per below:
Friday
7 2 0 0% 0%
Monday
75 24 20 27% 83%
Saturday
0 0 0
Sunday
20 1 1 5% 100%
Thursday
39 39 23 59% 59%
Tuesday
95 69 47 49% 68%
Wednesday

this is not how the information was entered.

WHAT DO I DO?
 
F

Fons Ponsioen

As Marshall already pointed out reports do their own
sorting/grouping.
So, in order to sort your table where you have given the
days criptic names, you must add a column an for instanc
ename it DaySeq (for day sequence), here you would mark
the days' sequence like 1, 2, 3 etc, than you can sort the
report base on this column and you do not need to include
it on the face of the report.
Hope this helps.
Fons
 
G

Guest

helps a lot thanks
-----Original Message-----
As Marshall already pointed out reports do their own
sorting/grouping.
So, in order to sort your table where you have given the
days criptic names, you must add a column an for instanc
ename it DaySeq (for day sequence), here you would mark
the days' sequence like 1, 2, 3 etc, than you can sort the
report base on this column and you do not need to include
it on the face of the report.
Hope this helps.
Fons
.
Click to expand...
 
Top