Hello, I'm trying to come up with some sort of query for what I need to accomplish but my SQL knowledge is very limited. What I'm trying to do is query two tables using .NET. I have one table that has the following fields:
and then several the rest of the fields are usernames.
By the way, this is in Access because that is all I have access to (no pun intended).
What this is is a training tracking application (somewhat). When a user completes a module, it adds a row into the 2nd table with all 5 fields filled out. The ModuleID, ModuleName and Quarter are all from the 1st table. I need to be able to filter (SELECT) all of the modules assigned to the user (anything with a yes in the username field) for a specific quarter and be able to show which modules have a CompletedDate (will be in 2nd table) and which don't (won't be in 2nd table). I'm not sure if any of this is making sense so I've added a diagram/example.
Any help on this would be GREATLY appreciated!
Last edited by DigitalDesignz; Sep 26th, 2012 at 02:18 PM.