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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Hi.
You formula =FabricBasePrice + FabricRiserI is correct and yes this will be corrected by Access to =[FabricBasePrice] + [FabricRiserI]. So far so good. Now you are getting Error# when you run the report. This usually indicates that in the source you have a field with the same name as this textbox "txtFabricPriceI". You may want to rename this textbox and I think the report will run fine. Hope this helps. Fons -----Original Message----- 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. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Page Margins | Vel | Setting Up & Running Reports | 6 | September 19th, 2004 09:46 PM |
programmatically add controls to report | G | Setting Up & Running Reports | 2 | August 4th, 2004 09:11 PM |
Report Fields | Josh | Setting Up & Running Reports | 5 | July 12th, 2004 04:28 AM |
Lookup fields on label report | Howard | Setting Up & Running Reports | 1 | June 3rd, 2004 02:43 AM |
Help Printing a Report with Blank Fields | Jen | New Users | 6 | May 1st, 2004 02:32 PM |