..hoping somone can help. I am importing data from an AS/400 by an ODBC link to the needed table. I am using an append table query so that I can retain the field properties I want in the destination Access table. My problem is with the fields from the AS/400 that represent business hours in time, for instance, one field is for the open time on Monday and the next field is for closed time, in hours and minutes. The problem is that the data is not stored in the AS/400 as a time/date field. In addition, some values are three digits (900 signifies 9AM) while others are four (2300 signifies 11PM). I need to change these to a time format so that I can do proper calculations on the fields (how many hours, mins is the business open on Monday). I've tried playing with input masks to no avail, as they only fill left to right, so the colon is not in the right place for the 3 digit times. Any help would be appreciated. Here is a sample of the data:
900
1000
900


0
2300
959
930
1330