Hello all, new member here trying to find help with Access.
Being a member of a fire department, record keeping is obviously a must due to state and federal inspections. It is key for us to be able to bring forth information when it is needed on things such as personnel training, vaccinations, injuries, call reports, and the list goes on.
I am pretty good with computers, however MS Access has become a challenge for me. I want to build the database myself, so that if any issues with it arise, I will have a good idea of how to deal with them.
I have started simple, building a Member List Table which gives the each members: Department ID(Primary Key), Alternate ID(for officers), Rank, First Name, Last Name, Active?(Yes/No), and other forms containing contact information.
I have had no trouble with this and things are going rather smoothly. I have also made a form allowing me to more easily enter this into fields.
The trouble arises when I am trying to build a report, based on active members. I have made a query that allows me to display such, active members in Ascending order by last, then first name.
I need the report to put those members in a table(4 columns by 21 rows) putting the first 20 members in the first column after the heading, skipping the second column for signatures, and filling in the rest in the third column, leaving the fourth column also open for signatures. Also, we add and lose members rather often, so I am unsure if it is possible to make the table dynamic(ie. If we only have 38 members we only need 20 rows).
I have managed to code in a way that shows the data like I want it to([LastName]+", "+[FirstName]), however I am lost as to how to get it in a table like this.
See column:
Thanks all for your help!!
Name Signature Name Signature Last, First Doe, John Smith, John