>>
>>I don't think that I understand what you mean by a separate date/time based table for the meters? Can you re-describe that? I have a table that records each time the meter is read along with the date/time of the reading.
>>
>>Thanks
>
>Oh - I just meant a table like:
>Meterid
>Location
>DatetimeInstalled
>Startreading
>Endreading
>DatetimeRemoved
>
>where meterid and location form the primary key. So a meter could be re-used after servicing perhaps.
>
>depends on whether you need this sort of info and how it fits in with your data model.
>HTH

Ok, I understand what you mean now. These are disposable hour meters, so when they break they are filed in the round file...

Thanks for the help on this.