I created a Third Party Database for program managers to use. These program managers are not computer literate, so I was trying to make the database easy to use.
The database comes from a form that the consultants(third party) fills out. I set the forms up just like the form that the consultants fill out. It is entered by me. My problem deals with the fact that my operations manager wants to be able to have a report based on the expertise and industry.
Experience has 4 different fields and so does industry. I connected the table with numbers. It worked this way but it only pulls the numbers that you list. So I would have to create a bunch of queries to get this to work.
I thought about creating a search, but I have used very little of SQL and VBA. I thought that if you would create a search, then it would look at all the expertise and industry categories. If you know how to help me out that woulld be great.
Amy Scivally
The database comes from a form that the consultants(third party) fills out. I set the forms up just like the form that the consultants fill out. It is entered by me. My problem deals with the fact that my operations manager wants to be able to have a report based on the expertise and industry.
Experience has 4 different fields and so does industry. I connected the table with numbers. It worked this way but it only pulls the numbers that you list. So I would have to create a bunch of queries to get this to work.
I thought about creating a search, but I have used very little of SQL and VBA. I thought that if you would create a search, then it would look at all the expertise and industry categories. If you know how to help me out that woulld be great.
Amy Scivally
