Search results

I tried pulling the refInstitution table into the query but it just makes the query not display any information. Not sure what I am doing wrong. I have included a graphic of the query.

I have three tables the tblStudentInfo (holding the persons main data), the tblEducation (holding the students education records) and the refInstution (holding all university's and college information) I am pulling PersonID, name, etc from the tblStudentInfo, education records from...

I have a main form and a subform. The main form displays the information as combo box = column.2 (in other words it shows the actual word not recordid y/n checkbox = obviously shows which is checked however the subform shows combobox = 1 or 2 etc the recordid y/n check box 1 for...

FIXED! here is the solution SELECT Sum(tblCourseTaken.Units) AS TotalCredits, tblCourseTaken.[790ID], tblCourseTaken.CourseStatus FROM tblCourseTaken WHERE (((tblCourseTaken.CourseTypeID)=1 Or (tblCourseTaken.CourseTypeID)=2)) GROUP BY tblCourseTaken.[790ID], tblCourseTaken.CourseStatus HAVING...

FIXED: here is the solution SELECT Sum(tblCourseTaken.Units) AS TotalCredits, tblCourseTaken.[790ID], tblCourseTaken.CourseStatus FROM tblCourseTaken WHERE (((tblCourseTaken.CourseTypeID)=1 Or (tblCourseTaken.CourseTypeID)=2)) GROUP BY tblCourseTaken.[790ID], tblCourseTaken.CourseStatus HAVING...

the fields being used are: Course Type 1=Core, 2=Elective, 3=Non-degree and 4=Transferred Course Status completed, withdrew, incomplete Fields in use by query: UnitCoreTotal, UnitElectiveTotal, and UnitTotal Unit Core works with: SELECT Sum(tblCourseTaken.Units) AS...

Bob, Hoping you can help me with this small glich. I have added another type of course "Non-Degree" with a designation of 4. The problem arises only in the Total Unit query. Since I have put this in as "completed" it adds the course to the total. SELECT Sum(tblCourseTaken.Units) AS...

Thanks. Due to a lot of hard work, research to find best methods and how to implement them, and definitely a lot of help from the terrific people on here.

Thank you so much. I even had that down to try in my notes and just missed it, thinking that would not make so much difference. Ah well, still learning. Again I can't thank you enough for all the help you and everyone on here has given me.

Ok I have pared down the database to just the relevant main (basic) and relevant form (Course). If you will notice that when I set the query for "Required - Completed" it give and #Error in the requiredunit and totalunit field. But if i entered say "Core-CoreCompleted" i get a the...

I need to separate the units into type and then program total. this will allow me to know which type of course is missing at a glance. I have four unbound field ReqUnit, CoreUnit, ContentUnit, TotalUnit for query input. Drawing from these field. Field 1 = cboCourseType (Required, Core...

I DID IT!!! Thanks to everyone for their help. Solution: Create a query based off the fields in the table of the form you want the subform to display. Be sure to include on both the main form and in the query: 1. The autonumber in the table (RecordID) 2. The information to limit what...

I DID IT!!! Thanks to everyone for their help. Solution: Create a query based off the fields in the table of the form you want the subform to display. Be sure to include on both the main form and in the query: 1. The autonumber in the table (RecordID) 2. The information to limit what...

I DID IT!!! Thanks to everyone for their help. Solution: Create a query based off the fields in the table of the form you want the subform to display. Be sure to include on both the main form and in the query: 1. The autonumber in the table (RecordID) 2. The information to limit what...

Unfortunatly the boss want both views together (doesn't care how tho) hence trying the list box that i could not get to work as it displays every record (see above). Would making the datasheet view the main form and the entry view the sub form work with what I need to accomplish?

I know that I should use a List Box, but I can not get that to work either, it displays all course records not just the ones for a particular student. I do not care which way it is just as long as I can get it to work that selection in the MANY (either sub or list) opens the record in the ONE...

That is exactly what I am trying to do. (Using Access 2010). I want to use the cascading combo's to reduce potential errors but need to display all associated records (which I did get it to do) and yet be able to select a record in the subform and have it load to the main form (which I can...

OK if you open the database and select the Course Work button it takes you to the form / subform. The main form (frmCourseTaken) is where the student course records are entered, stored in tblCourseTaken. The subform (frmsubCourseSummary) is built off a query (qryCourseSumary) that pulls...

Attached is a pared down version of my database to the form causing the problems. Open the database and select Course Work. I have a form that uses a subform. I need to be able to synchronie the two so a selection in the subform loads that record to the main form for editing. As I am...

I can not get it to work. It lets me select different choices but continues to record the same record instead of letting me choose multiple records for the same person. I am going to put a shortened version of the database (with only the form giving me trouble) on here and hope someone can...