Sum() Problem?

[Buj123]

Hi,
This seems simple but not working for me.
i have 3 tables that have relationship in between. I have created a Query out of those 3 and used that query as Recordsource to my report. And the report has all the fields that the query has.
I should show the Total of "TotalSavings" filed. So i have added a textbox to the report and in its controlsource i have entered like below
=Sum(qrySSScoreCard!TotalSavings)

But its not working. "qrySSScoreCard" is my query.

 

[Lightning]

=Sum([TotalSavings]) should be all you need. Put your textbox in the Group Footer or Report footer.

HTH
Lightning

 

[SmallTime]

I'm not sure if this can be done, but here goes.

I have a textbox, TxtStartDate, on a form which displays the current date, Date(). What I want in another text box is to display the current date plus, say, 10 days. Easy enought you may think, but the tricky part is that I have to take into account weekends and public holidays and exclude these from the 10 days.

My initial thoughts are to use the NETWORKDAYS function but don't know how to code this.

Any ideas?

 

[SmallTime]

My sincere apologies I've obviously posted in the wrongly. I blame lack of sleep.

Sorry.
SmallTime
ZZzzz...