I have been assigned a task involving a Resume Database. What I have been handed is a file that consists of a table with approximately 91 columns to it. It basically has all the info off a person’s resume on it. There are several attempts at queries and forms and ect but nothing successful. I have started completely rebuilding the table so that I can make sure there is nothing hidden anywhere. Here is what they want to be able to do:
Pull resumes based on various skill levels (each skill is identified in individual columns), as well as by education level (here again is spread across 4 columns), and would like a return selection based on other various options. Some of these options may be combined or individual. Here’s my issue: I have written several queries and table queries that allow for data to be entered so that results are user defined but none that I have written will return the multiple results or continue to return 100 results when only 15 actually apply. Help???
