report info not in order

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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.
 
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?
 
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?
 
Back
Top