AnsweredAssumed Answered

Filter function?

Question asked by Melinda on Dec 11, 2008
Latest reply on Dec 11, 2008 by Melinda


Filter function?


Please bear with me as I try to explain what I need to do...  I'm not sure it can actually be done, but I am hoping someone will tell me it can...


I need to be able to create a report, by instructor name, that shows all of the projects a particular instructor has worked on - each project has a specific number id.  The problem is that we may have up to six instructors listed per project, so Jane Smith, for example, might be instructor 1 for one project and instructor 3 for another. Instructor fields are labeled Instructor 1 FN and Instructor 1 LN (two separate fields).


Ultimately, I'd like to be able to enter the instructor's name and have a list of all projects she's been a part of regardless of her instructor number.  Is this possible?  If I need to clarify anything in order for you to help me, please let me know, I am really stumped!!


Thank you!