counting (dSum)

  • Thread starter Thread starter toby
  • Start date Start date
T

toby

column A B(item) C(unit price) D(quantity) E
F

if i 've label certain item with "a01" in column A, then is it possible to
calculate the total quantity of all items labelled "a01"??
is it possible to make this calculation in the footer??
how to do it?
thanks in advance

Toby
 
To sum the [Quantity] field in a group or report footer for records where
[Item] = "a01", use a text box with a control source of:
=Sum(Abs([Item] = "a01") * [Quantity])

Next time, you can leave out the column letters and just provide the field
names. It makes your question easier to understand.
 
thx duane
i know the problem, i've put the formula into the last 2 region (not the
footer) .
but is it possible to show the formula result on every page ?!


Duane Hookom said:
To sum the [Quantity] field in a group or report footer for records where
[Item] = "a01", use a text box with a control source of:
=Sum(Abs([Item] = "a01") * [Quantity])

Next time, you can leave out the column letters and just provide the field
names. It makes your question easier to understand.

--
Duane Hookom
MS Access MVP


toby said:
column A B(item) C(unit price) D(quantity) E
F

if i 've label certain item with "a01" in column A, then is it possible to
calculate the total quantity of all items labelled "a01"??
is it possible to make this calculation in the footer??
how to do it?
thanks in advance

Toby
Click to expand...
Click to expand...
 
I don't understand what you mean by "the last 2 region". If you want page
totals, check this KB Article
http://support.microsoft.com/default.aspx?scid=kb;en-us;216311&Product=acc2000

--
Duane Hookom
MS Access MVP


toby said:
thx duane
i know the problem, i've put the formula into the last 2 region (not the
footer) .
but is it possible to show the formula result on every page ?!


Duane Hookom said:
To sum the [Quantity] field in a group or report footer for records where
[Item] = "a01", use a text box with a control source of:
=Sum(Abs([Item] = "a01") * [Quantity])

Next time, you can leave out the column letters and just provide the field
names. It makes your question easier to understand.

--
Duane Hookom
MS Access MVP


toby said:
column A B(item) C(unit price) D(quantity) E
F

if i 've label certain item with "a01" in column A, then is it
Click to expand...
Click to expand...
possible
to
Click to expand...
Click to expand...
 
Back
Top