Hi all,
I am building a report which displays [item_description],[item_cost], and [item_contributor_ID]. I've managed to make a textbox in the report footer which sums the [item_cost] column to give a total cost of all items that were bought. My problem is: I would like to have another textbox that lists the sum of [item_cost] by [item_contibutor] but I cannot figure out how to specify the criteria. There are only two contributors so I want a textbox for each of those two which sums their contributions. Here is a non-functioning version of what I want to do
textbox
control source: =SUM([item_cost]) where [item_contributor_id] = 1
Can anyone help?
I am building a report which displays [item_description],[item_cost], and [item_contributor_ID]. I've managed to make a textbox in the report footer which sums the [item_cost] column to give a total cost of all items that were bought. My problem is: I would like to have another textbox that lists the sum of [item_cost] by [item_contibutor] but I cannot figure out how to specify the criteria. There are only two contributors so I want a textbox for each of those two which sums their contributions. Here is a non-functioning version of what I want to do
textbox
control source: =SUM([item_cost]) where [item_contributor_id] = 1
Can anyone help?
