Get it right before I start

[BRISBANEBOB]

I want to use a Userform to capture data received by phone. The user who is capturing the data will receive up to 28 bits of data from the customer - up to 4 readings per day for 7 days, but the user may sometimes only get 4 or 8 readings.

The customer has a unique number, and I need to be able to record this data from the Userform in such a way as to make retrieval easy. As I see it, I have the unique customer number, four bits of data per day. Would I use a combination of these to enable retrieval? I have no experience in this area so any advice on how to structure it all before I start would be welcomed.

[TMS]

Depends, I think, on how you want to view and/or analyse the data. If you only want to locate the data, then you could record Customer ID, Date, Time and all the Readings ... whether it's 4, 5, 6, 7 or 8, it doesn't matter; all the readings on one row.

If you want to count the readings, it might be better to have Customer ID, Date, Time, Reading index ( 1 to 8) and Reading

[BRISBANEBOB]

Thanks - it all makes sense.

[TMS]

You're welcome.