List Box that populates Values and provides a total in a Report

B

BZeyger

Hello,

I currently have a custom report which I created. I have a list box that
provides numerious values. These values need to be calculated.

The current listbox has
SELECT [Proposals qry].Value FROM [Proposals qry] WHERE ((([Proposals
qry].Project)=[reports]![Weekly Report - CSOT DDG 110 - 112]![project name]));
in the row source.

I have another textbox in which I need to calculate the total to that list
box.

How would I do this?
 
K

Ken Sheridan

Assuming the Project value is a text data type try the following as the text
box's ControlSource property:

=DSum("Value",""Proposals qry","Project = """ & [Reports]![Weekly Report -
CSOT DDG 110 - 112]![project name] & """")

If Project is a number data type omit the literal quotes:

=DSum("Value",""Proposals qry","Project = " & [Reports]![Weekly Report -
CSOT DDG 110 - 112]![project name])

Ken Sheridan
Stafford, England
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Unable to display values in 2nd list box from 1st list box selection 2
store a value of a text box that calculates data into a data sourc 2
Report filters by checked box 4
Access getting values from List Box using VBA 1
SUBTRACT true ckbx value in report 11
Table headers in a list box (Custom Report) 3
Grand Total in a report 4

Top