I want to flag a number if it is used twice within 12 months

[bhudwa]

I have a table which consists of a number, if this number is input twice in a 12 month period then this item needs to flag the user, as this number is under a 12 month warrenty, would this be done in a query in microsoft access.

 

[Crowley16]

you can certainly find out the numbers of occurrences of pieces of data within bounds, but you would have to build some sort of notification code in order to notify a user of this...

--------------------
Procrastinate Now!

 

[bhudwa]

Do does anyone know the code for this, for example if the number 12345 was in put in to a field it should notify the user with a message that the number is under a 12 month warrenty, this should only happen if the number has been used in last 12 months. there is also a date field, so is there a code or a formula i can use that can do this

Thankyou
Bhudwa

 

[PHV]

You may consider the DLookUp function in the BeforeUpdate event procedure of the control in the data entry form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244