Formatting the output of a crosstab query...

[MrDay]

I have a cross tab query that tells me the number of
events which happen during different time intervals (Row
Headers) by day of the week (Column heading). Instead of
giving me the Column Headings in the standard week format
(Sunday, Monday, Tuesday, Wed...) I get it in alphabetical
order (Friday, Monday, Saturday, Sunday, etc...).

My format expression is currnetly Format(Weekday
([Date]),'ddd'). What else do I need to do, and is there
anyway to make it start with Monday and go through Sunday?

Marcus

 

[Allen Browne]

Try entering the names of the days into the Column Headings property of the
query.

If that still does not work, you could create a report based on the crosstab
query, and lay the fields out as desired.

 

[Duane Hookom]

I rarely expose a query datasheet to my users so it doesn't make much
difference what order the fields are in. I use forms and reports where I set
the display.

That said, you can open the query properties and enter
Column Headings: "Sunday","Monday",..."Saturday"

 

[jay]

I agree with previous posts and also have noticed that if you use the
wizard, it magically sorts the crosstab chronologically. If not, I've never
been able to get it to do it.
Jay

 

[Bas Cost Budde]

I have a cross tab query that tells me the number of
events which happen during different time intervals (Row
Headers) by day of the week (Column heading). Instead of
giving me the Column Headings in the standard week format
(Sunday, Monday, Tuesday, Wed...) I get it in alphabetical
order (Friday, Monday, Saturday, Sunday, etc...).

My format expression is currnetly Format(Weekday
([Date]),'ddd'). What else do I need to do, and is there
anyway to make it start with Monday and go through Sunday?

Marcus

You can prefix the column headers (in the data source) with the day
numbers. You will get 1 Sunday 2 Monday 3 Tuesday and if you can live
with that, it works.

Is Sunday day one for non-jewish people as well?