Delete query maximum values

Tech-Archive recommends: Fix windows errors by optimizing your registry

I want to make a delete query that deletes all the items that are in the
minorty. For example, in the field “ Houses ” there are 10 rows with value
1 , 3 rows with value 3 and 4 rows with value 6. In this case I must
delete all values except the value 1
I suppose the code should use Dcount, Max or something like that but I
cannot do it. Any help ?”

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200708/1

.

Relevant Pages

  • Delete Query maximum values
    ... I want to make a delete query that deletes all the items that are in ... the minorty. ... in the field " Houses " there are 10 rows ... I suppose the code should use Dcount, Max or something like that but ...
    (comp.databases.ms-access)
  • Re: Delete Query maximum values
    ... delete * from foo ... select top 1 houses ... the minorty. ... I suppose the code should use Dcount, Max or something like that but ...
    (comp.databases.ms-access)
  • Re: Complex logic query that I cannot figure out:(
    ... I am working on a query that pulls from 3 tables. ... Table 2 - houses all counts for the users ... Oracle Ace Director & Instructor ...
    (comp.databases.oracle.server)
  • Complex logic query that I cannot figure out:(
    ... I am working on a query that pulls from 3 tables. ... Table 2 - houses all counts for the users ... LEFT OUTER JOIN ...
    (comp.databases.oracle.server)
  • Returning the first character of each word in a field
    ... I have a field that houses a first and last name (I don't ... want them in separate fields). ... I want to run a query that ... Any assistance is much appreciated. ...
    (microsoft.public.access.queries)