Originally Posted by
ssanfu
...
Your table is not normalized. You will have problems (and probably tear out your hair) with the current table structure...
Absolutely! You're committing what many call 'Spreadsheet by Database!' You should have a Main Form, based on a Table with the a RecordID (as the Primary Key,) operator's name, date and machine number, then a Subform based on a second Table having a RecordID (as a Foreign Key,) UpTimesStart, UpTimesStop, DownTimesStart, DownTimesStop and EventCode.
The the Tables would be related via the RecordID, and there would be a separate Record, in the Subform, for each event.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007