A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Total control on report with control on subreport



 
 
Thread Tools Display Modes
  #1  
Old May 21st, 2004, 11:12 PM
Deann
external usenet poster
 
Posts: n/a
Default Total control on report with control on subreport

I have a report/subreport where the report has a control
with a number in it (A) and the subreport has a control
with another number in it (B). I had the following
formula in control C on the main report and it used to
work before my system was upgraded to Access 2003.

=[A])+([Report]![Subreport]![b])

I've also tried the following:

=([A])+([Reports]![Mainreport]![Subreport]![b])

The results that I receive is the total of "A" only. It's
as if it can't find a number in "B".

Has the syntax changed? I've search the help and can't
find anything different. Any advice would be greatly
appreciated.
  #2  
Old May 21st, 2004, 11:52 PM
Deann
external usenet poster
 
Posts: n/a
Default Total control on report with control on subreport

Found the answer to my own question. Thanks. I found that
someone else had the same question on May 14th under the
subject "Calculated Control" and it worked.

In essence -- for those looking for the answer. My
formula changed to:

=([A])+([Subreport].[Report]![b])

-----Original Message-----
I have a report/subreport where the report has a control
with a number in it (A) and the subreport has a control
with another number in it (B). I had the following
formula in control C on the main report and it used to
work before my system was upgraded to Access 2003.

=[A])+([Report]![Subreport]![b])

I've also tried the following:

=([A])+([Reports]![Mainreport]![Subreport]![b])

The results that I receive is the total of "A" only.

It's
as if it can't find a number in "B".

Has the syntax changed? I've search the help and can't
find anything different. Any advice would be greatly
appreciated.
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.