Problem with database!

[AccessNewb11]

Hi Access friends!

I'm having an issue with my DB, and I believe it's a novice issue. I am building a database to help me register people for law enforcement classes. I would save their name, agency, class information, etc. in a record and then create a query for each class that will act as a roster for the class. For instance, I will create a query for Arresting 101 (not a real class!) and set the date criteria as the date for that class and my hope is that everyone I entered in my master form with that class and that date will pop up in the query.

Well...I created a query to test two people I entered for a perishable skills course. The query did NOT retrieve these 2 records. I have a feeling that my database is setup wrong...whatever horrible way I set it up, I am prepared for and know I may have to really fix some stuff to get this up and running.

I have attached a copy of the database here. I'm sorry, but it won't let me save it in an older version, I'm not sure how...

The April 30 form is where I entered information for each person, and saved it as a record. The problem with this form is, when I go back to the form to look at John Doe, for instance, his agency name and contact person is not populated, even though I chose them when I entered him the first time. That makes me think that part of the form isn't being saved as being connected to John Doe, but I'm not sure how to do that...

The "Perishable Skills 8/27/14" is the query I created to pull records from the April 30 form, which isn't working.

I'm not sure how clear I am being. Please don't hesitate to ask me questions. Thank you.



And, in summary, my problem is: The query is not pulling up the two records I saved.

Please help! THANK you in advance!!!

~Laurel May~

[June7]

There are no records in Jointbl_Individ_ClassID. There are no records that associate individuals with classes. Add records to table.

The Jointbl_Individ_ClassID must save the ID from tblDateOfClass. Fix the linking in Relationship Builder. Need Jointbl_Individ_ClassID in the relationships.

IndividualID field should not be in tblNameOfClass.

The query should be (copy/paste this into SQL View of query builder then switch to Design View):

SELECT AgencyContact.ContactName, AgencyContact.EmailAddress, AgencyInfo.AgencyName, AgencyInfo.City, Individual.LastName, Individual.FirstName, Individual.POSTID, Individual.[PostReimburseable?], Individual.Cancelled, Individual.DateCancelled, Individual.DateEntered, Notes.Notes, Notes.Date, Processor.[Processor Name], tblDateOfClass.DateofClass
FROM tblNameOfClass RIGHT JOIN (tblDateOfClass RIGHT JOIN ((((AgencyInfo RIGHT JOIN AgencyContact ON AgencyInfo.[AgencyInfoID] = AgencyContact.[AgencyID]) RIGHT JOIN (Processor RIGHT JOIN Individual ON Processor.[ProcessorID] = Individual.[ProcessorID]) ON AgencyContact.[AgencyContactID] = Individual.[AgencyContactID]) LEFT JOIN Notes ON Individual.[IndividualID] = Notes.[IndividualID]) RIGHT JOIN Jointbl_Individ_ClassID ON Individual.IndividualID = Jointbl_Individ_ClassID.IndividualID) ON tblDateOfClass.DateofClassID = Jointbl_Individ_ClassID.NameOfClassID) ON tblNameOfClass.NameOfClassID = tblDateOfClass.NameOfClassID
WHERE (((tblDateOfClass.DateofClass)=#8/27/2014#));