Owen, Thankyou very much for taking the time to look at this for me Rgds
Lewis owen_group_profile <[EMAIL PROTECTED]> wrote: Hi, use the query QUI. in the first column have field1 & field2 then repeat that for column 2. then press the 'totals' button at the top of the screen. In the first column choose 'Group By'. In the second choose 'count'. As the criteria, enter: >1 below the count column. Run the query. hth, Owen --- 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 SPONSORED LINKS Microsoft access database Microsoft access Microsoft access database design Microsoft access database training --------------------------------- 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=12ht1m5k9/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123618518/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</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/
