I have a QA test results Database where the employee enters their name from a dropdown list every time the make an entry. I have a table that has their name and number.
In the database I am only storing their number. I have a query to show how many entries an employee made during an entered date range. I have pop up boxes that ask for the number and the dates.
When I make a report based on that query, I want to display the employee name instead of their number.
Joe Smith is number 5. Insead of the report saying number 5 entered 350 results, I want it to say Joe Smith entered 350 results.
How do I do that?
In the database I am only storing their number. I have a query to show how many entries an employee made during an entered date range. I have pop up boxes that ask for the number and the dates.
When I make a report based on that query, I want to display the employee name instead of their number.
Joe Smith is number 5. Insead of the report saying number 5 entered 350 results, I want it to say Joe Smith entered 350 results.
How do I do that?