I have what I consider a unique problem with Access 97 dates.

PROBLEM:

Rollup daily data to monthly data.

Initially worked fine. About a year ago experienced problems.
Eliminated daily dates Prior to 1935 from daily table.
RollUp worked fine until about a week ago.
Repaired and Compressed DB and problem went away after several attempts.
Today blew up again.

Prior to Rollup:
1) Repair and Compress do NOT resolve the problem

During Rollup (stepping through VB code with breakpoints):
When Access gets to the February 1937 daily record it resets the pointer back to the first Daily record.


After Rollup:
1) Access ONLY rolled up Daily to Monthly records for 1/31/36 to 1/31/37.
2) Access deleted from the monthly table key field (fldDate) --> both the Required = Yes and the Format of mm/dd/yyyy


DATA RANGE:

01/02/1936 to current date

TABLES -- Daily and Monthly:

fldDate (Key Field -> Date, Required, Format mm/dd/yyyy)
fldHigh Number -> Single
fldLow Number -> Single
fldClose Number -> Single

------------------------------------------------------------------------------------

Thanks
David