Reading expiry dates

[croiva25]

I have an application where we print labels and capture certain info about gadgets we place the labels on.
I have just added an ability to upload serial numbers for device we use, table contains ID(autonumber),Colour,SerialNumber,ExpiryDates.

So we use these devices until they don't expiry and then we get them reset and in the mean time start using new batches with new serial numbers and expiry dates, and so on.

So I have a number of small screens where we log that device is used, it has been returned, or it has lost its parameters but basically what I need to do is also pay attention to the expiry dates when devices are returned as users might forget to do so, so I need to be able to read the exipiry date that goes with that serial number and when it is about to expiry or has expired to let them know.

I use Access 97 database.
I was hoping somebody would share a similar example with me or give me so sample code as I am not sure how to track expiry dates since there doesn't seem to be a logical time frame for how long they are ok to use, company providing us with devices determines expiry dates.

Any help is appreciated.

 

[alehawk]

So what you need to do is to get all serias for products that are going to expire in 5 days from now for example?
Suposing you got the serial:
Is you neet to see the date from a serial you sould use
"Select serial, datefield from mytable where serial=" & yournumber

Then get the records as normal.