Checking for duplicate data in a field using Acces

  rps1106 16:00 17 Jan 2006

Hi All,
I work for a voluntary organisation in a hospital environment. Older patients coming into A&E will get sent a letter from us offering help.

We send out about 3,000 letters a year and have just over this number of records on our simple database.

The problem I have is when we enter data using a Form in the field Address Line 1 if we have sent a letter to this address before I want somehow for the program to inform me of this. However, I do not want it to stop me from entering the same address again so I can't use the No Duplicates option. The reason being, we may have sent the patient a letter six months ago in which case we would want him to receive another but if we only sent him a letter say 3 weeks ago then we wouldn't send him another.

At present we look at the admissions list, sort our table into Surname order and check if they have been sent one previously, however this is very time consuming and would value anyone's thoughts.

Does this makes sense?

Thank you in advance.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Turn a photo into 16-bit pixel art

iMac Pro release date, UK price & specs

Comment suivre le parcours du père Noël ?