Okay, I have created an access database that we are using at church for the kids ministry. It is working great. The secretary puts in the date, chooses from a list of services (Sunday 9am, Sunday 11am, Wednesday) that are chosen from a list, Classes (nursery, toddlers, etc) that are chosen from a list, and then there is a multivalued list that has all of the kids listed and they check off what kids were there and then submit.
Now, I need to run a report on a set of dates, which I know how to do, but when I run the report, it gives me numbers instead of the child's name or the class. So the report I have now shows the date and service appropriately, but the attendance.kidid.value shows 6,7,8,9,202, and the class shows 3.
How can I get those things to show up as the actual values instead of the access values? Is there something I can run or setup to fix this? I want to make it as low maintenance as possible