Recent content by dashah

This is an existing database that I inherited. I appreciate the help Terry. I will keep checking to see if anyone has other ideas as well. I will also try what "Braindead2" suggested. I am new at Access programming so all the help is appreciated. Thank you all in advance. p.s. By...

OK here is the sample data: Asset# Date_Cal Date_Due 0555 3/12/98 3/12/99 0555 3/12/99 3/12/00 0555 3/12/00 3/12/01 0556 5/6/97 11/6/97 0556 11/6/97 5/6/98 0556 5/6/98 11/6/98 I want to catch the past due data which would be the last record for both asset nos 0555 and 0556...

The assets are listed by an asset number. So, I have a history of each asset added to the table every time a calibration maintenance action takes place. e.g. asset no. 0555 may have five records detailing the calibration history. Now, I want to extract the latest record from that history when...

Thank you for the prompt reply. However the date_calibrated already has the previous calibration date. To complicate things, the calibration interval varies (3, 6, 12 months). The database entry is made after the calibration so the date_calibrated and date_due is input at that time. Any...

I have a calibration/maintenanence data base with two tables. one being a master inventory reocrd with asset numbers and the other an actual history of the maintenance calibration records. My problem: When I query the table for past due (<Date()in Date_Due) items, all the records for the items...