DSum ? Question

[Stefan Hoffmann]

hi,

Amount Discount
$10.00 10%
$10.00 5%
How would I Do a DSum on this...?
TextTotal = DSum("[Amount]*[Discount])

I need to get the total amount discounted.

Just do it. Use =DSum("[Amount]*[Discount]", "Table")


mfG
--> stefan <--

 

[DS]

I have a table with an Amount field and a Percent field, the data would be
as such.

Amount Discount
$10.00 10%
$10.00 5%

How would I Do a DSum on this...?
TextTotal = DSum("[Amount]*[Discount])

I need to get the total amount discounted.
Thanks
DS

 

[DS]

Your right. For some reason I didn't hink that it would be accurate, nor
easy!!!!!
Thanks
DS

hi,

Amount Discount
$10.00 10%
$10.00 5%
How would I Do a DSum on this...?
TextTotal = DSum("[Amount]*[Discount])

I need to get the total amount discounted.

Just do it. Use =DSum("[Amount]*[Discount]", "Table")


mfG
--> stefan <--