Sorting in a report

[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

 

[Duane Hookom]

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?

 

[Evi]

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

 

[quinto via AccessMonster.com]

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

 

[Duane Hookom]

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?

 

[quinto via AccessMonster.com]

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

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:

[quoted text clipped - 18 lines]

 

[Duane Hookom]

You can set the "Force New Page" property of group headers and/or footers.
--
Duane Hookom
Microsoft Access MVP

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

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:

[quoted text clipped - 18 lines]

Quinto

 

[quinto via AccessMonster.com]

You make it so simple for me
Let me know if you ever come to New York City

Thank you

Quinto

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?

[quoted text clipped - 12 lines]