I'm working on an access database. I need to put some values of measurement points into the database (every day 25-50 centers send these measurement points to us) It are about 50 floating point numbers. Some of the values are related to each other. Now I've got in my database 21 related numbers saved as a string, 10 related numbers saved as a string, ... But I also need to do calculations on them and I need to send them to a graph and a grid, ... For that I always have to extract them out of the strings.
Question : Is there a better way?
Like : Save all values to database as floating points
(Better? More place on harddisk?)
Is there another type which is usefull?
> Easy to handle a collection of numbers
> Quick for display and 'real-time'
Perhaps in future other handlings with data?
> So is it the best to write them as numbers?
Thanks in advance.