Re: error selecting duplicate records in Access

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

Dear Riccardo:

Please post the SQL View of the query here, so we can see what is the nature
of the problem.

Generally, it would be unusual to use an aggregate when looking for
duplicates. How did you happen to choose that?

Tom Ellison


"Riccardo" <Riccardo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B1E8167C-C131-4425-9298-EC556FAB821B@xxxxxxxxxxxxxxxx
I tried to make a query for selecting the duplicate records in another
query,
based on a calculated field. I got a message (error 3122), saying that my
query does not include the calculated field formula as part of an
aggregate
funcion. Anybody can help? Thank you.


.

Relevant Pages

  • Re: Question on Group By
    ... YOU cannot use * to refer all fields in an aggregate query. ... If you are trying to group by a calculated field, ...
    (microsoft.public.access.queries)
  • Re: Question on Group By
    ... "John Spencer" wrote: ... aggregate query. ... an aggregate and in the GRoup by clause you have to list each specific ... If you are trying to group by a calculated field, ...
    (microsoft.public.access.queries)
  • Re: Text field causing trouble in query (continued)
    ... This makes your query an "aggregate" query. ... >I have three columns in my query: customer ID, Age, ... >The expressions in Age and Emp are each reading four ...
    (microsoft.public.access.queries)
  • Re: Get Result 1 Stdev Away From Mean
    ... that query in another query applying condition ... Hidden within the Access crosstab query is the ... Terms with aggregate functions are required since the crosstab query is a special ... employeeid for shipcountry.The cells of the crosstab contain ...
    (microsoft.public.access.queries)
  • Re: Is ROLLUP really better than doing a nested query when rank is involved?
    ... potentially filled with columns that contain the aggregate data ... I meant here by homing in: within the same query - using ... sales BUT with their subtotals as well... ... the totals and subtotals... ...
    (comp.databases.oracle.server)