D
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?
I get a field to be displayed in columns rather than rows?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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.
D
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.
J
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.