I am trying to create a report and I have it done, but it is very messy. I am hopeing there is a cleaner way of getting this done. Here is what I have and the issues:
I have a resident worksheet that has the following columns:
Name, ID#, Room, Date Arrived, Date Review, Date departed.
I have a...