Ask Software Development Questions and Get Answers ASAp
Hi there and welcome
You wont get this done via the Macro builder, its a method for building very simple macros, not data checking macros. You would need to actually code it in a VBA module within access, which is not too hard, but requires some basic knowledge of VBA.
Have you done any VBA coding before?
If so, I can explain the main elements, if not, it would be easier if I did this for you as an additional service and have made the offer for this.
If you accept it I can write the code and implement it for you