Hi Richard! Thankyou very much for taking the time to look at this for me Rgds Lewis
Richard <[EMAIL PROTECTED]> wrote: One way to do it is make sure that both fields are primary keys. If both are primary keys, then you can have duplicates of one that don't have duplicates of the other - but not duplicates of both. This is often called a "composite key". I manage a MSN group on Access; e- mail me privately ([EMAIL PROTECTED]) for more details on that. HTH! Alienwebmaster --- In [email protected], "lewiskidd" <[EMAIL PROTECTED]> wrote: > Hi all! > > Wondering if some kind person can help me with a problem that I > currently have at the moment ? I need to develop a query that checks > to establish if there is more than one instance of the same site > code. > > The site code is derived from two separate four digits combined to > give the site code. Box A would contain 3020 and box B would contain > a four digit number that exists in sequence for example 7010. Box A > + B would then provide a site code of 30207010. There should never > be two site codes for the same area that are the same, so there > should never be two 30207010s but you can have a 30107010 or > 31007010. > > I have attempted to use Access to solve the problem using the > duplicate wizard but it failed to weed out a deliberate double entry > that I inserted to check the effectiveness. I also tried to use the > QBE screen and adding criteria of >1 but this has also failed. > > Can anyone help me with this please ? > > > Rgds > > > Lewis --------------------------------- YAHOO! GROUPS LINKS Visit your group "AccessVBACentral" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12he515vk/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123618403/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
