D Dale Walker Jan 19, 2004 #1 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'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?
J John Vinson Jan 19, 2004 #2 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? Click to expand... With a Crosstab query, using the day as a column header. See the online help for Crosstab.
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? Click to expand... With a Crosstab query, using the day as a column header. See the online help for Crosstab.
D Dale Walker Jan 19, 2004 #3 With a Crosstab query, using the day as a column header. See the online help for Crosstab. Click to expand... 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.
With a Crosstab query, using the day as a column header. See the online help for Crosstab. Click to expand... 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 Jan 19, 2004 #4 The problem is, the data still needs to be editable. I seem to remember crosstabs being readonly. Click to expand... 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.
The problem is, the data still needs to be editable. I seem to remember crosstabs being readonly. Click to expand... 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.
