User Profile
Emilyharp
Copper Contributor
Joined Apr 10, 2020
User Widgets
Recent Discussions
Need help building a form that allows for several rows of entries per column (Excel style)
I am creating a database through Access for employee end of shift reports. Currently these reports are not being stored in a database and instead are filled out on an Excel file. The Excel format works well for these specific reports. Employees enter multiple rows of data with column values such as Task Completed, Time Completed, Room #, etc. Being new to Access, I am having issues recreating this kind of format in Excel. I don't know how to allow an employee to enter multiple times in one field (column) under one form. I have learned about the multivalue field option, however many of the items employees must enter are free-response short text, not Lookupwizard drop down menus. Secondly, these multiple values for each field must be associated with other fields that need multiple values (like the row function in Excel, each task has a time and room # associated with it and there are multiple tasks). Is there an eloquent solution to this problem I am having? It has been hard to research the answer on my own because I don't know how to ask the question.1.2KViews0likes2Comments
Recent Blog Articles
No content to show