Report Sorting

  • Thread starter Thread starter NigelP
  • Start date Start date
N

NigelP

I have made a report based on a query. in the design of
the query I have asked it to be sorted by Time 9:00,
12:00, 14:00 and 16:00.

In the query this works fine, but in the report it puts in
the order that it was entered into the database, is there
any way to fix this.

Nigel
 
In the report design view click on the sorting and grouping button in the toolbar (also in view menu) select the field you want to sort by and choose ascending or descending. Hope that helps.
 
The date/time field probably has a date as well as a time component.

Use a query as the RecordSource of the report, and enter a calculated field
by typing something like this into a fresh column of the Field row in query
design:
TimeValue([MyField])
Sort on that field.

You may find that there are some oddities in the way fields sort that appear
to have the same time, due to the inaccuracies of the way Access stores time
values.
 
Back
Top