field displayed in colums across

[Dale Walker]

I'm trying to create a 'Calendar' view of a month in a form. How can
I get a field to be displayed in columns rather than rows?

 

[John Vinson]

I'm trying to create a 'Calendar' view of a month in a form. How can
I get a field to be displayed in columns rather than rows?

With a Crosstab query, using the day as a column header. See the
online help for Crosstab.

 

[Dale Walker]

With a Crosstab query, using the day as a column header. See the
online help for Crosstab.

It's been a while but I vaguely remember trying to use crosstabs
before without success.

The problem is, the data still needs to be editable. I seem to
remember crosstabs being readonly.

 

[John Vinson]

The problem is, the data still needs to be editable. I seem to
remember crosstabs being readonly.

That's correct; they are.

You may want to use a bound temporary non-normalized table, or an
unbound Form with VBA code to move the data into your real tables.
Unfortunately, you cannot get a datasheet appearance with records
going across the screen.