Sorting in a report

  • Thread starter Thread starter quinto via AccessMonster.com
  • Start date Start date
Q

quinto via AccessMonster.com

I am having problems keeping the records sorted in a report pages.
I selected a group by a field and sorting ascending
The next field also selected ascending but there a few records out of order.
I checked the entries and are all same format and correct. (Hours and minutes)


Thanks

Quinto
 
What are your expressions in the sorting and grouping control sources? Where
do these expressions come from?

How are typical values displayed in your report?
 
My immediate bet is that those hours and minutes have a date hidden behind
them. This could happen if you eg you have put a Default Value of Date() in
your Time field and then chosen to Format is as hours and minutes. (Your
default value should have been Now())

In a query containing your time field, go to Format([YourTimeField],
"dd/mm/yy") and see if the dates shown are different. If yes then we will
have to amputate the the time from the date to make the sort work.

Evi
 
I placed the group filed in the page header and selected: Group Header: Yes,
Group Footer: No, Group On: Each Value, Group Interval: 1, Keep Together:
Whole Group.
I Place the time in the details section and selected: Group Header: no, Group
Footer: No, Group on: Each value, Group interval: 1, Keep Together: No

The control field was always formatted as Short time

I hope this help

Thanks

Quinto
 
I think your issue may be that you are attempting to sort on a formatted
value. Is the "time" field just a field name or some value with formatting
applied in the query or expression?
 
I just realized whats happening. the sorting is fine but the grouping is not
How do I get to dispaay/print each group in a different page?

Thanks for your great help

Quinto

Duane said:
I think your issue may be that you are attempting to sort on a formatted
value. Is the "time" field just a field name or some value with formatting
applied in the query or expression?
I placed the group filed in the page header and selected: Group Header: Yes,
Group Footer: No, Group On: Each Value, Group Interval: 1, Keep Together:
Click to expand...
[quoted text clipped - 18 lines]
Click to expand...
 
You can set the "Force New Page" property of group headers and/or footers.
--
Duane Hookom
Microsoft Access MVP


quinto via AccessMonster.com said:
I just realized whats happening. the sorting is fine but the grouping is not
How do I get to dispaay/print each group in a different page?

Thanks for your great help

Quinto

Duane said:
I think your issue may be that you are attempting to sort on a formatted
value. Is the "time" field just a field name or some value with formatting
applied in the query or expression?
I placed the group filed in the page header and selected: Group Header: Yes,
Group Footer: No, Group On: Each Value, Group Interval: 1, Keep Together:
Click to expand...
[quoted text clipped - 18 lines]
Quinto
Click to expand...
Click to expand...
Click to expand...
 
You make it so simple for me
Let me know if you ever come to New York City

Thank you

Quinto

Duane said:
You can set the "Force New Page" property of group headers and/or footers.
I just realized whats happening. the sorting is fine but the grouping is not
How do I get to dispaay/print each group in a different page?
Click to expand...
[quoted text clipped - 12 lines]
Click to expand...
 
Back
Top