sorting by day of the week

[Guest]

i have created a crosstab query which totals volume by each day of the week.
I would like these to appear in order i.e Monday, Tuesday, etc instead of
alphabetical order. Is this possible? Much appreciated

 

[Rick Brandt]

i have created a crosstab query which totals volume by each day of
the week. I would like these to appear in order i.e Monday, Tuesday,
etc instead of alphabetical order. Is this possible? Much appreciated

Use the ColumnHeadings property.

In design view of the query put the cursor into the column having the Crosstab
entry of "Column Heading" and then open the property sheet. You should see a
property named "Column Headings". In that property enter...

"Monday";"Tuesday"; etc...

This not only allows you to specify the order of the columns, but it also forces
a column for every entry in the RecordSet even if that particular cilumn has no
data.

 

[Guest]

Cheers Rick for your help. However my day values are actually in the Row
headers as opposed to the Column headers. So the solution below does not
work.

 

[Rick Brandt]

Cheers Rick for your help. However my day values are actually in the
Row headers as opposed to the Column headers. So the solution below
does not work.

Then you need to add an additional RowHeader field to the query that formats the
date as the day number (1= Sunday, 2=Monday, etc..). You can sort on that field
and display the other.