S Stefan Hoffmann Mar 13, 2007 #1 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. Click to expand... Just do it. Use =DSum("[Amount]*[Discount]", "Table") mfG --> stefan <--
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. Click to expand... Just do it. Use =DSum("[Amount]*[Discount]", "Table") mfG --> stefan <--
D DS Mar 13, 2007 #2 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
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
D DS Mar 14, 2007 #3 Your right. For some reason I didn't hink that it would be accurate, nor easy!!!!! Thanks DS Stefan Hoffmann said: 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. Click to expand... Just do it. Use =DSum("[Amount]*[Discount]", "Table") mfG --> stefan <-- Click to expand...
Your right. For some reason I didn't hink that it would be accurate, nor easy!!!!! Thanks DS Stefan Hoffmann said: 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. Click to expand... Just do it. Use =DSum("[Amount]*[Discount]", "Table") mfG --> stefan <-- Click to expand...
