Total from SubReport Data But Not in SubReport

[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

 

[Duane Hookom]

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.

 

[Novice2000]

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

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

 

[Duane Hookom]

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

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

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

 

[Novice2000]

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.

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

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

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