Formatting the output of a crosstab query...

  • Thread starter Thread starter MrDay
  • Start date Start date
M

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

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?
 
Back
Top