Using Sum in a field with duplicate records

[KrazyKT]

I am trying to create a text box with a calculation format. I want to sum the field excluding the duplicate quantities. Is there a way in doing this instead of just using =Sum([Quantity]). This will give me a sum that has the duplicate quantities in it.
Thanks,

KT

 

[MichaelRed]

Create a query with the unique records. Do the math (on the query w/ unique records). Or, create a second query which does the sum (Aggregate query) which selects only the unique records.


MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over