[RESOLVED] SQL Beginner
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:
ID (Autonumber)
ModuleName (Text)
ModuleLink (Text)
Quarter (Text)
and then several the rest of the fields are usernames.
The second table has the following fields:
ModuleID (Number)
ModuleName (Text)
Quarter (Text)
Username (Text)
CompletedDate (Text)
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!
Featured
Writing your app was the hard part, but it’s not the last part. You still need to sell your app. Here's how to make sure your description puts your app in the best light. |
|
Reply With Quote
