gary.newport
Registered User.
- Local time
- Today, 21:47
- Joined
- Oct 14, 2009
- Messages
- 79
Hi everyone
I want to build a form (I know this is the query area but the query is where the error is; I think). The form will give, at the top, the House colour for a school (we have 6 Houses) and then the selected Tutor Group (we have 6 tutor groups per house). This part I have working without issue.
The base form uses a query that contains the Houses, Tutor Groups, After School Activities, a compound statement combining the student's name, the date of the activity and then the student's first and last names to allow the system to be sorted by these fields.
I wanted to build a cross-tab query on this query so that it would take the tutor group code and only list the relevant students and activities undertaken, counting the dates for each student/activity.
I have built the cross-tab but when I run it I get the error of too many column headings (which must relate to the 1200 students and not the single column heading I have assigned to the cross-tab). In the actual query it would, at most, list 40 students but I cannot get the query to run and cannot base any new sub form based upon the cross tab query; purportedly due to the error.
How much of this is wrong?
I want to build a form (I know this is the query area but the query is where the error is; I think). The form will give, at the top, the House colour for a school (we have 6 Houses) and then the selected Tutor Group (we have 6 tutor groups per house). This part I have working without issue.
The base form uses a query that contains the Houses, Tutor Groups, After School Activities, a compound statement combining the student's name, the date of the activity and then the student's first and last names to allow the system to be sorted by these fields.
I wanted to build a cross-tab query on this query so that it would take the tutor group code and only list the relevant students and activities undertaken, counting the dates for each student/activity.
I have built the cross-tab but when I run it I get the error of too many column headings (which must relate to the 1200 students and not the single column heading I have assigned to the cross-tab). In the actual query it would, at most, list 40 students but I cannot get the query to run and cannot base any new sub form based upon the cross tab query; purportedly due to the error.
How much of this is wrong?
