summing costs from multiple records...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I have a field that I want to display on a form. This field would be the sum
of all "cost" fields from another table...

The SQL would be something like this...

select sum(cost) from [tasks].[cost] where [tasks].[issue_no] = me.issueno

How do I set up a calculated field to do this? SHould I not be able to place
this SQL code in the fields "Control Source" property? I tried that and the
field simply shows "Error"

Any help would be appreciated...

Brad
 
You can't define a fields control source by an sql query.

You have to use the function : DSum

Jack
 
Back
Top