Total from SubReport Data But Not in SubReport

  • Thread starter Thread starter Novice2000
  • Start date Start date
N

Novice2000

Hello,

This is probably pretty simple, but I have created a report where the main
display is a subreport of items ordered by the customer order and price. I
would like to total the prices in the main report, but not from a total on
the subreport. The price field is called Expr5.

I have tried =Sum([Expr5]), but this gives and #Error
 
I can't figure out what you are asking. If you don't want the total from the
subreport, what do you want? Values displayed in a report must come from
somewhere. "Expr5" means nothing to any of us other than you haven't taken
the time to properly name a column or some other object in your database.
 
Yes, I want the total from the subreport, but I don't want to total it in the
subreport but at the bottom of the main report. I have renamed the field:

I have tried =Sum([Price_Unit]), but this gives and #Error

Duane Hookom said:
I can't figure out what you are asking. If you don't want the total from the
subreport, what do you want? Values displayed in a report must come from
somewhere. "Expr5" means nothing to any of us other than you haven't taken
the time to properly name a column or some other object in your database.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Novice2000 said:
Hello,

This is probably pretty simple, but I have created a report where the main
display is a subreport of items ordered by the customer order and price. I
would like to total the prices in the main report, but not from a total on
the subreport. The price field is called Expr5.

I have tried =Sum([Expr5]), but this gives and #Error
Click to expand...
Click to expand...
 
Total the value in the subreport. You can hide it if you want. Then reference
the subreport total text box in your main report.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Novice2000 said:
Yes, I want the total from the subreport, but I don't want to total it in the
subreport but at the bottom of the main report. I have renamed the field:

I have tried =Sum([Price_Unit]), but this gives and #Error

Duane Hookom said:
I can't figure out what you are asking. If you don't want the total from the
subreport, what do you want? Values displayed in a report must come from
somewhere. "Expr5" means nothing to any of us other than you haven't taken
the time to properly name a column or some other object in your database.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Novice2000 said:
Hello,

This is probably pretty simple, but I have created a report where the main
display is a subreport of items ordered by the customer order and price. I
would like to total the prices in the main report, but not from a total on
the subreport. The price field is called Expr5.

I have tried =Sum([Expr5]), but this gives and #Error
Click to expand...
Click to expand...
Click to expand...
 
I gave you a yes this was helpful, but I am right where I started except that
I had to put up with insults.

I could have named this anything and it wouldn't have mattered to our
discussion. I could have named it =Sum([Duane_Hookums]). And, I think it was
pretty clear what I was asking. You must be having a bad day, but there is no
need to share it. I came here for help not insults.



Duane Hookom said:
Total the value in the subreport. You can hide it if you want. Then reference
the subreport total text box in your main report.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Novice2000 said:
Yes, I want the total from the subreport, but I don't want to total it in the
subreport but at the bottom of the main report. I have renamed the field:

I have tried =Sum([Price_Unit]), but this gives and #Error

Duane Hookom said:
I can't figure out what you are asking. If you don't want the total from the
subreport, what do you want? Values displayed in a report must come from
somewhere. "Expr5" means nothing to any of us other than you haven't taken
the time to properly name a column or some other object in your database.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Hello,

This is probably pretty simple, but I have created a report where the main
display is a subreport of items ordered by the customer order and price. I
would like to total the prices in the main report, but not from a total on
the subreport. The price field is called Expr5.

I have tried =Sum([Expr5]), but this gives and #Error
Click to expand...
Click to expand...
Click to expand...
 
Back
Top