View Single Post
  #1  
Old September 27th, 2004, 09:27 PM
A man
external usenet poster
 
Posts: n/a
Default A2000: calculated fields on a report detail

How do I calculate values in a field on a report detail?

First I have database fields called FabricBasePrice and FabricRiserI. The
report recordsource is DB3SET.*, along with fields ID, and Inactive.

In a text box on the report detail, I have the Controlsource as
FabricBasePrice, the text box is called txtFabricBasePrice.

In a new text box, called txtFabricPriceI, I want the calculated price. So I
tried these:
=FabricBasePrice + FabricRiserI

Access turns it into: =[FabricBasePrice] + [FabricRiserI]

I got an error when I previewed the report.

So I tried: =Me!FabricBasePrice + me!FabricRiserI
I got an error. Something like missing field I think.

I also tried: =Me.FabricBaePrice + Me.FabricRiserI
but got an error.

I also tried the expression builder, which basically put in the same thing I
did: =FabricBasePrice + FabricRiserI

Anyone know how I make a caculated field? Thanks.

--
Image alchemy: turning pictures of lead into pictures of gold.