sql statement in control source 1

[Bullsandbears123]

HEllo,

I have a non-binding form with a text box.

I put

=(SELECT sum([table1]![field1]) FROM table1

as my control source but all I get is "name?"

What's wrong and how can I get this to work?

 

[jebry]

Hi!

If you mean that this is in the control source of the text box then you need to use:

=DSum("[field1]", "table1")

hth


Jeff Bridgham
bridgham@purdue.edu

 

[PHV]

Try something like this:
=DSum("[field1]", "table1")


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Bullsandbears123]

Works PERFECTLY!! THANKS!