Windows XP 
Access 2010 32bit
In trying to create an easy to use training database, I have been playing around with queries and have done everything that I think will be useful including the ability to look up what training an employee has completed and the date it was completed, as well as the training required for that employee. What I'm struggling with right now is figuring out a way to make a query which will eventually become a sub-form showing the complete list of training required with the dates they completed that module next to it, and if they haven't finished that module than the date space will be left blank. So far I've been successful, but the only problem I run into is that when I make this query it ends up repeating the dates as shown below:
I have tried every combination of Left and right joins to try and make it work but at this point I'm at a loss. Here is the design view if that helps at all.
The whole database is based on this sample and I really haven't deviated from this structure at all.
This is the last little bit before I'm completely done, and I have a feeling it's something incredibly simple that I'm missing!
Reply With Quote
