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

store a value of a text box that calculates data into a data sourc 2
Access getting values from List Box using VBA 1
Multi Select list box as parameter for report or query? 1
Table headers in a list box (Custom Report) 3
Help! i cant get Nz function to work in report! 1
Calculating a grand total for an unbound control in a report 9
Automatic Text in Report 2
Report list in a drop-down box 8

Top