sorting by day of the week

M

Mr Singh

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
 
R

Rick Brandt

Mr said:
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
Click to expand...

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.
 
M

Mr Singh

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.
 
Top