HI,
I need your help as i am struggling to figure out what is the best way to structure my DB for keeping records of the following:
I am trying to store a monthly water usage for several locations. for instance, i will have locations (Chicago, New York, LA, ....) and for each of those i need to store a monthly water usage. i will therefore have the following data:
- New York, June 2010, 30'000
- New York, August 2010, 40'000
- Chicago, June 2010, 25'000
etc...
I created a table with the list of location, what do i do for the monthly volume?
what is the best way to strucutre this?
I am fairly new at access as you can guess, so thanks for your precious help!
I