Getting rid of duplicated data

[NBellamy]

I currently have a table that I’ve created from a query. There is a field named Required Hours(RH) that has duplicated values in it along with other fields. When running a report, created from the table, I make sure that the duplicated values I RH are hidden. I want to create a sum for RH, in the report. How would Access allow me to sum the unique values of the RH field?

 

[Rich]

Why do you need to create a table from a query to produce a report.

 

[NBellamy]

I work with 20 to 30 different tables. I create a table from a query as a snap-shot in time. But even if I just create a report from a query how do I get rid of the duplicated values in a field and how do I sum on the unique values?