Recent content by CATC

The spelling error was not a problem. I blame that on my less than desireable naming system. I was unfortunately not able to get it to work. I was able to get nanscombes suggestion to work and I am now in the process of adding fields to provide more filtering options. Thank you for your...

Rain and nanscombe, I was able to get it to work experimenting with both of your solutions. Now I just need to step up and understand why they workedJ Thank you !

Just the fact that there is a record indicates that it is complete. Thank you for the suggestion. I will give it a try.

I apologize to all, I am having a hard time putting all of this into words and to further complicate things, I am a novice. So I know I am not asking the correct questions and possibly not understanding the suggestions. Rain: The issue is that I can’t get the criteria correct. Attached is a...

My mistake, you are correct. I had a date column in the original query that filtered training dates of a certain age. I will add it back and try the DISTINCT keyword . Thanks!

Okay I have simplified the query, but the issue remains. The query as shown below returns employees who have training topics 11 or 14. So John Doe who has taken both topics is listed twice. I have tried “And” instead of “Or” and get no returns. Any suggestions? SELECT...

The original query was filtered by campus with a combo box on a form and by work status to eliminate inactive employees. I took some of the criteria out while playing with the query. I will try your suggestion though and simplify things to work it out. Thanks

Hello, This is my first time posting to this site and I wanted to thank you for what is accomplished here. This site has helped me through many problems! Please forgive the phrasing of this question if it is not clear. I have struggled with how to ask it for some time. I have a query that is...