Hi all,
I've been given a task to take an existing Excel spreadsheet and transfer it to Access. I'm a novice in Access, and I'm having trouble designing a way to lay out the data in tables that would make sense. I know there will be plenty of headaches down the road if I don't have a good starting point.
The Excel Spreadsheet is set up as follows, where there's 5 units, 8 locations to measure at, as well as a range and average for each location across all units. Like so...
Unit# | x x x x x | Range Ave
Loc 1 | * * * * * | * *
Loc 2 | * * * * * | * *
Loc 3 | * * * * * | * *
.....
I have tried to have all measurement data in a table (loc1_unit1, loc1_unit2, etc.) and left out calculated fields, but I'm at the point where I have to take averages across fields, and I'm just hoping there's a better way. I originally did it that way because the person I got the project from wants to still be able to enter all five units at once (make the form look like the spreadsheet).
Any thoughts? Thanks in advance.
-Pat
I've been given a task to take an existing Excel spreadsheet and transfer it to Access. I'm a novice in Access, and I'm having trouble designing a way to lay out the data in tables that would make sense. I know there will be plenty of headaches down the road if I don't have a good starting point.
The Excel Spreadsheet is set up as follows, where there's 5 units, 8 locations to measure at, as well as a range and average for each location across all units. Like so...
Unit# | x x x x x | Range Ave
Loc 1 | * * * * * | * *
Loc 2 | * * * * * | * *
Loc 3 | * * * * * | * *
.....
I have tried to have all measurement data in a table (loc1_unit1, loc1_unit2, etc.) and left out calculated fields, but I'm at the point where I have to take averages across fields, and I'm just hoping there's a better way. I originally did it that way because the person I got the project from wants to still be able to enter all five units at once (make the form look like the spreadsheet).
Any thoughts? Thanks in advance.
-Pat
Last edited: