hi, sorry for this lame post, database has been displaying the last record and all attending data nicely for the last 2 years and suddenly will not display the last record, seems stuck on a record 2 entries previous, in design view can get last record by using max( was using last ), but in date field it will not display the last" date, or last" data with it. flummoxed as what to do ? any help would be helpful