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
Thanks,
KT