Subform

G

Guest

I'll try again. I'm using standard template for classroom mgt. I have added
field for date completed under students taking course in a subform of classes
form. Have added same field to Student and Classes table and Student and
Casses query. Date appears in classes subform, Student and classes table and
student and Classes query.
Problem is on the student subform for the classes they have taken, the date
completed doesn't show. I always get a "#Name?" in the space.
I am sure it is somewhere in the record source for the form, which I have
cut and pasted below

SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID;

I have tried inserting "[Student Suform Subquery].DateCompleted everywhere
in the above, but it only makes all the records show errors.
 
G

Guest

Try this --
SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)], [Student Subform Subquery].DateCompleted
FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN Classes ON
Instructors.InstructorID = Classes.InstructorID) ON Departments.DepartmentID
= Classes.DepartmentID) INNER JOIN [Student Subform Subquery] ON
Classes.ClassID = [Student Subform Subquery].ClassID;
 
G

Guest

Appreciate the help. but it didn't work. When inserted, it made all the other
records have record source faults and couldn't open form until changed back.
Can't believe having so much trouble with this.

As I said this is the Access classroom management templete. There has to be
another explaination for why it wont work.
--
Thanks for your help,
Greg


KARL DEWEY said:
Try this --
SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)], [Student Subform Subquery].DateCompleted
FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN Classes ON
Instructors.InstructorID = Classes.InstructorID) ON Departments.DepartmentID
= Classes.DepartmentID) INNER JOIN [Student Subform Subquery] ON
Classes.ClassID = [Student Subform Subquery].ClassID;


Greg said:
I'll try again. I'm using standard template for classroom mgt. I have added
field for date completed under students taking course in a subform of classes
form. Have added same field to Student and Classes table and Student and
Casses query. Date appears in classes subform, Student and classes table and
student and Classes query.
Problem is on the student subform for the classes they have taken, the date
completed doesn't show. I always get a "#Name?" in the space.
I am sure it is somewhere in the record source for the form, which I have
cut and pasted below

SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID;

I have tried inserting "[Student Suform Subquery].DateCompleted everywhere
in the above, but it only makes all the records show errors.
Click to expand...
Click to expand...
 
G

Guest

it made all the other records have record source faults
Did you edit out and returns that posting/copying/pasting may have added
into the SQL?

Greg said:
Appreciate the help. but it didn't work. When inserted, it made all the other
records have record source faults and couldn't open form until changed back.
Can't believe having so much trouble with this.

As I said this is the Access classroom management templete. There has to be
another explaination for why it wont work.
--
Thanks for your help,
Greg


KARL DEWEY said:
Try this --
SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)], [Student Subform Subquery].DateCompleted
FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN Classes ON
Instructors.InstructorID = Classes.InstructorID) ON Departments.DepartmentID
= Classes.DepartmentID) INNER JOIN [Student Subform Subquery] ON
Classes.ClassID = [Student Subform Subquery].ClassID;


Greg said:
I'll try again. I'm using standard template for classroom mgt. I have added
field for date completed under students taking course in a subform of classes
form. Have added same field to Student and Classes table and Student and
Casses query. Date appears in classes subform, Student and classes table and
student and Classes query.
Problem is on the student subform for the classes they have taken, the date
completed doesn't show. I always get a "#Name?" in the space.
I am sure it is somewhere in the record source for the form, which I have
cut and pasted below

SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID;

I have tried inserting "[Student Suform Subquery].DateCompleted everywhere
in the above, but it only makes all the records show errors.
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

Thanks Karl,
Not sure exactly what I did, but you got me there. Thank you so much.
--
Thanks for your help,
Greg


KARL DEWEY said:
Did you edit out and returns that posting/copying/pasting may have added
into the SQL?

Greg said:
Appreciate the help. but it didn't work. When inserted, it made all the other
records have record source faults and couldn't open form until changed back.
Can't believe having so much trouble with this.

As I said this is the Access classroom management templete. There has to be
another explaination for why it wont work.
--
Thanks for your help,
Greg


KARL DEWEY said:
Try this --
SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)], [Student Subform Subquery].DateCompleted
FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN Classes ON
Instructors.InstructorID = Classes.InstructorID) ON Departments.DepartmentID
= Classes.DepartmentID) INNER JOIN [Student Subform Subquery] ON
Classes.ClassID = [Student Subform Subquery].ClassID;


:

I'll try again. I'm using standard template for classroom mgt. I have added
field for date completed under students taking course in a subform of classes
form. Have added same field to Student and Classes table and Student and
Casses query. Date appears in classes subform, Student and classes table and
student and Classes query.
Problem is on the student subform for the classes they have taken, the date
completed doesn't show. I always get a "#Name?" in the space.
I am sure it is somewhere in the record source for the form, which I have
cut and pasted below

SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID;

I have tried inserting "[Student Suform Subquery].DateCompleted everywhere
in the above, but it only makes all the records show errors.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform 7
Sort order in subform 1
SQL query with Many-To-Many relationship??? 2
An Unmatched Query? 2
proper syntax to place table data onto report 11

Top