Matrix Data Storage in Microsoft Access
Sunday May 18, 2008
In a recent forum posting, Rjones_17 wrote:
"I’m new to Microsoft Access and need some advice. I’m currently attempting to map out the offsets of ships, given a body plan. Basically I end up with numerous curves, each for a specific coordinate of the ship (say X coordinate), from which I can deduce numerous Y and Z coordinates for each curve/X coordinate. I was wondering if it were possible to store something like a matrix in a single slot in Microsoft Access (2003), so I could have the X coordinate in one slot, and then all of the Y-Z pairs that go along with that X coordinate in the next slot. If this isn’t possible are there any suggestions on how to store this information in a user friendly manner?"
Join the forum discussion: Matrix Data Storage in Microsoft Access
"I’m new to Microsoft Access and need some advice. I’m currently attempting to map out the offsets of ships, given a body plan. Basically I end up with numerous curves, each for a specific coordinate of the ship (say X coordinate), from which I can deduce numerous Y and Z coordinates for each curve/X coordinate. I was wondering if it were possible to store something like a matrix in a single slot in Microsoft Access (2003), so I could have the X coordinate in one slot, and then all of the Y-Z pairs that go along with that X coordinate in the next slot. If this isn’t possible are there any suggestions on how to store this information in a user friendly manner?"
Join the forum discussion: Matrix Data Storage in Microsoft Access
You can store a matrix in a text field (memo field probably, since you’ll be dealing with more than 255 characters) as a string with some type of delimiter (comma or pipe or semicolon). You also might be able to get away with using Excel. It just matters what you want to do with the data or how you want to access it.