Report Total on Form

[uplink600]

I have a report in an Access database which is based on a standard query. On the report I have a total which I get using the formula.......

=SUM([Project Value])

This works fine and I get the correct value. Question is I want the same value to appear on a form in my database in a standard text box. Trouble
is I get the total of all the projects in the database when I use the same
formula as above in the control source dialog. Please advise how I get the value of projects using the "Orders Won" query.

I know this is probably easy but could someone please advise, I haven't used the expression builder before.

Thanks in anticipation

VC

 

[KenHigg]

Use dsum(). Or better yet look in the vba section of this forum and use Mile-Philes MSum(). I think this is what he calls it and I think he has it tweaked...

ken