Search results

I do need that extra date field. When I said I don't care about it, I meant in terms of grouping. I want the report to show (most importantly) when the course is required again, but also, just as an fyi, when the course was last completed. I will try the Is Not Null idea. Thanks again. With...

Wow, I am impressed, thanks for taking the time to re-create my database on your own computer. My company's paid IT people are not as thorough. I see what my problem was. I had an extra date field that I did not include in my table description above. The extra field was the date the course...

I have what is probably a simple question for regular Access users. Before I ask the question, here is a simplified version of the tables involved: Structure of EMPLOYEE ===================== EmplID Name Structure of TRAINING ===================== EmplID CourseID CourseName DateTaken Data...

Your suggestion sounded somewhat challenging but after an hour of googling and playing around it Access, it worked just fine. Thanks!

Thanks for the quick reply. With just two tables, it seems to give me what I need. (see first screen shot) When I add another table (courses taken) there is a problem - it shows each occurance of an absence as many times as there are courses for that person. (second screen shot) With the...

'Two queries / one report' seems to be a common topic, but I still can't find the information I need. Normally I am pretty good at finding answers through google or by searching a forum like this one, but in this case I don't know exactly what I'm looking for help on. Let's say I have two...