By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Crosstab query error 3070

P: n/a
I would really appreciate a nudge in the right direction on how to
resolve this issue, as despite checking previous listings still not
getting anywhere.

I have 4 tables

tblApplicant_Person
App_Person_ID PK
tblInterview
Interview_ID PK
App_Person_ID FK
Site Accepted

tblCompendium
Course_ID PK
Course Name
Division

tblCourses_Applied
Course_App_ID PK
App_Person_ID FK
Course_ID FK

I want to create a crosstab query, which has column headings 'Site
Accepted' and row headings 'Division'.
I can get this to work easily. The problem is that an Applicant may
apply for one or more courses from the compendium. I only want to
count each Applicants first choice of course and so the division that
course belongs to.
I have managed to this in a select query using the following code in
the criteria of Course_app_id in the QBE grid.
Code: WHERE((([Courses_Applied].[Course_App_ID])=(SELECT
Min(A.Course_App_ID) FROM Courses_Applied AS A WHERE A.App_Person_ID =
Courses_Applied.App_Person_ID)))

However when I try to run the crosstab I get the following error:
The Microsoft Jet database engine does not recognize
'Courses_Applied.App_Person_ID' as a valid field name or expression.
(Error 3070).

Any help would be gratefully accepted.
thanks
Carl

Sep 4 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.