Ordering Records in a Group

[Guest]

I created a basic database that tracks hours/days worked. The report is
grouped on the [Date_Worked] field and that seems to be working properly. In
the sorting/grouping dialog box, I chose the [Date_Worked] field, sorting it
in ascending order.

However, the dates are not sorting in order. I'm not quite sure how they are
sorted, but it certainly isn't by Date within the group month.

Thanks,
Robert

 

[Guest]

Ooooooooops.......... I forgot to mention the report is grouped by MONTH on
the [Date_Worked] field. Sorry about that.

Robert

 

[Duane Hookom]

Could you provide your exact Sorting and Grouping entries with the field
data types?

 

[Guest]

[Could you provide your exact Sorting and Grouping entries with the field
data types?]

[Date_Work] is a Date/Time field.

The report is grouped by MONTH on the [Date_Work] field.
Group Header: Yes
Group Footer: No
Group On: Month
Group Interval: 1
Keep Together: Whole Group

On the top portion of the dialog box, in the Field/Expression column is the
field [Date_Work]
In the sort/order column, the choice is ascending.

Is this the information you requested?

Robert

 

[Duane Hookom]

Do you have the field [Date_Work] twice, once for the month and then again
for the actual date?

 

[Guest]

[Do you have the field [Date_Work] twice, once for the month and then again
for the actual date?]

Yes, I used the same field for both grouping and sorting.

Robert

 

[Duane Hookom]

I just want to double check, you have two Sorting and Grouping levels

[Date_Work] this is the monthly level with the header
[Date_Work] this is the "naked" date field

 

[Guest]

[I just want to double check, you have two Sorting and Grouping levels

[Date_Work] this is the monthly level with the header
[Date_Work] this is the "naked" date field]

The answer to your question is Yes.

Robert

 

[Duane Hookom]

What is the Record Source of your report? Are you applying any formatting to
the date field in your query?

What happens if you create a brand new report with the same record source
and then set the sorting and grouping?

 

[Guest]

[What is the Record Source of your report?]

tblTimeAttend

[Are you applying any formatting to
the date field in your query?]

There is no query invovled, I'm using the table listed above. And the only
formatting done is in the page header of the report where the date is changed
to the name of the MONTH.

[What happens if you create a brand new report with the same record source
and then set the sorting and grouping?]

As soon as I have some free time, I'll give that a shot.

Thanks,
Robert