Creating forms from crosstabs. The forms will overlap the columns and not display totals. Only have a maximum of 31 columns. Will only go to 15 or so then overlap and not allow the form to be expanded. Would like to have column totals also. Why and how please. Thanks.
Forms from crosstab queries
- Thread starter Marky
- Start date
Thanks Ranman256. I have tested that already but I'm stubborn and believe there is always an answer however tough. If I have to then so be it as the deadline is very tight. I know I push against the odds and in this case I guess that may well be the fix. Thanks again for your time. Always having problems with forms!!! Have a good day.
The idea of overlapping the form with column headings is not necessary. You just need to have a fixed number of column headings. See here:
http://www.fmsinc.com/MicrosoftAccess/query/crosstab-report/index.html
As for totals you'll be able to calculate that after you've build the form.
http://www.fmsinc.com/MicrosoftAccess/query/crosstab-report/index.html
As for totals you'll be able to calculate that after you've build the form.
Similar threads
