>I have tried what you said with adding the same fields and checking SUM when I do so it asks reset based on report or page whichever I select on my end report all it shows for quantity summed fields is **** I tried the same thing just with a quick report and same outcome,
>
>Any ideas what I have skipped or ???
>
>Thanks
>
>Also the except clause worked perfectly for the record transfer Thanks again for that
>
>Fred W.
Hi Fred,
Glad to hear you solved your other problem. As for this one - the solution is simple - you just need to make the fields wider. If you don't have enough room, you may need to make format something small, like 999,999.99 (Make sure it would be enough for your sum, though).
If it's not broken, fix it until it is.
My Blog