crosstab for day of week

[klp via AccessMonster.com]

I have a crosstab query that puts the day of week but I would like it to put
each day, Monday thru Friday even if there is no data. How do I accomplish
this?

Thanks!
Kim P

 

[Jerry Whittle]

Easy! Open the crosstab query in design view; right click in the area near
the tables; and select Properties. Next go into the Column Headings and put
in something like:

'Monday,'Tuesday','Wednesday','Thursday','Friday'

Note: The above will prevent Saturday or Sunday from showing up even if
there is data for them.

 

[klp via AccessMonster.com]

Fabulous! How easy is that! Thank you!!!

Easy! Open the crosstab query in design view; right click in the area near
the tables; and select Properties. Next go into the Column Headings and put
in something like:

'Monday,'Tuesday','Wednesday','Thursday','Friday'

Note: The above will prevent Saturday or Sunday from showing up even if
there is data for them.