Query based on duplicates fields

[dealwi8me]

maybe some stupid questions....

How can i create a query based on duplicates values of a field?

and another question...

Is it possible to create a query based on the sum of some fields?

Thank you

 

[FoFa]

Use the Query Wizard to create a duplicate check query (easiest way).

Create a query to SUM the fields you want, then write another from that original query is one way. Or create a "group by" query and sum the fields in one query. Depends on what you are trying to do.

 

[dealwi8me]

Use the Query Wizard to create a duplicate check query (easiest way).

...how can I create a duplicate check query from wizard?I didn't find such an option.