Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-18-2006, 12:21 PM   #1
NDBadger
Registered User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
NDBadger is on a distinguished road
Finding missing classes, pt II

First I want to thank everyone who sent me a response to my original problem. Unfortunately I still have not been able to get the results that I need. So for those new individuals who may have missed my original thread I will try again:

I have 1 table (Student Records) that looks like this:

Last Name, First Name, Class Title, Completion Date

And I have a 2nd Table (Course List) that looks like this:

Class ID, Class Title, Frequency

What I am looking for is a query to tell me which of the classes in the table Course List are not in Student Records Table. Basically I needto know which students haven't completed a course.

Any help will be appreciated. Thanks

NDBadger is offline   Reply With Quote
Old 07-18-2006, 12:24 PM   #2
NDBadger
Registered User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
NDBadger is on a distinguished road
I should also mention that I have a third Table listing all of the students names.
NDBadger is offline   Reply With Quote
Old 07-18-2006, 12:34 PM   #3
KeithG
AWF VIP
 
KeithG's Avatar
 
Join Date: Mar 2006
Location: Illinois
Posts: 2,592
Thanks: 0
Thanked 4 Times in 4 Posts
KeithG will become famous soon enough KeithG will become famous soon enough
can you post your db?

KeithG is offline   Reply With Quote
Old 07-26-2006, 08:27 AM   #4
NDBadger
Registered User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
NDBadger is on a distinguished road
Thanks KeithG.
Attached Files
File Type: zip ancillary1.ZIP (334.5 KB, 60 views)
NDBadger is offline   Reply With Quote
Old 07-26-2006, 08:31 AM   #5
NDBadger
Registered User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
NDBadger is on a distinguished road
Thanks KeithG.
NDBadger is offline   Reply With Quote
Old 07-26-2006, 08:33 AM   #6
NDBadger
Registered User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
NDBadger is on a distinguished road
thanks for the help
Attached Files
File Type: zip ancillary1.ZIP (334.5 KB, 60 views)
NDBadger is offline   Reply With Quote
Old 07-26-2006, 08:42 AM   #7
KeithG
AWF VIP
 
KeithG's Avatar
 
Join Date: Mar 2006
Location: Illinois
Posts: 2,592
Thanks: 0
Thanked 4 Times in 4 Posts
KeithG will become famous soon enough KeithG will become famous soon enough
Do you need to know which classes each student has not taken or which classes have not been taken by any student?

KeithG is offline   Reply With Quote
Old 07-26-2006, 09:48 AM   #8
NDBadger
Registered User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
NDBadger is on a distinguished road
Both would be nice but what I originally wanted was to have a list of those people who have not taken the course.
NDBadger is offline   Reply With Quote
Old 07-27-2006, 05:02 AM   #9
KeithG
AWF VIP
 
KeithG's Avatar
 
Join Date: Mar 2006
Location: Illinois
Posts: 2,592
Thanks: 0
Thanked 4 Times in 4 Posts
KeithG will become famous soon enough KeithG will become famous soon enough
Look at qryNotTaken is this what you wanted?
Attached Files
File Type: zip H.ZIP (339.3 KB, 63 views)
KeithG is offline   Reply With Quote
Old 07-27-2006, 05:22 AM   #10
NDBadger
Registered User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
NDBadger is on a distinguished road
Thanks. It looks like what I am needing, however when I ran the query looking for the class "TIP" it came back with 103 records found when in fact it should have been more like 70-80 records. Not sure why that is. Also Is there a way to use a combo box to select which class I want so I don't misspell and get back flase info?

I really do appreciate your help.
NDBadger is offline   Reply With Quote
Old 07-27-2006, 06:02 AM   #11
KeithG
AWF VIP
 
KeithG's Avatar
 
Join Date: Mar 2006
Location: Illinois
Posts: 2,592
Thanks: 0
Thanked 4 Times in 4 Posts
KeithG will become famous soon enough KeithG will become famous soon enough
I made some changes to your table design. You didn't have your tables normalized so I made a few changes. I would probably take the 2-yr , Annual , and One time field and put them in the course table. Unless some people have to take a class once and others every year. You will alse notice a form called frm example.
Attached Files
File Type: zip H.ZIP (360.7 KB, 66 views)
KeithG is offline   Reply With Quote
Old 07-27-2006, 06:34 AM   #12
NDBadger
Registered User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
NDBadger is on a distinguished road
Looks great

Thanks for the help

NDBadger is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing data chrisp General 5 12-03-2008 08:55 PM
Find Missing Classes NDBadger Queries 5 07-11-2006 11:36 AM
I need help Pls!!! darksniper General 21 09-08-2005 08:30 AM
Count Missing Elements Kila Reports 5 05-17-2005 04:14 AM
Finding the missing values chrisbrookeanna Queries 1 04-16-2004 04:15 AM




All times are GMT -8. The time now is 04:50 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World