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
|
|||
|
|||
Data Access Page
I have a snapviewer report that has a field called "Extended Total" it is a
text box with the following syntax =sum[unitprice1]*[itemcost1]. It is also on the entry form this way; however, there is not a field in the database table for the Extended Total for each row of data. The form and the report only show the above syntax. Now here is my problem, I have made a Data Access Page report using my table data as the source, but there is no total cost for the row of data. I have all the other fields from the field list pulled to the Data Access Page and I tried putting a text box on the form for each row that needs the extended cost, but it just shows the formula in the field. I need the field to reflect the unitprice1 * itemcost1, not the formula. Any way to fix this? |
#2
|
|||
|
|||
Data Access Page
I don't really know that much about DAPs. I tried using them once, but found
them to be almost useless. The only thing I could think of is to use a query and create a calculated field in the query for the report. -- Dave Hargis, Microsoft Access MVP "Clois Beckwith" wrote: I have a snapviewer report that has a field called "Extended Total" it is a text box with the following syntax =sum[unitprice1]*[itemcost1]. It is also on the entry form this way; however, there is not a field in the database table for the Extended Total for each row of data. The form and the report only show the above syntax. Now here is my problem, I have made a Data Access Page report using my table data as the source, but there is no total cost for the row of data. I have all the other fields from the field list pulled to the Data Access Page and I tried putting a text box on the form for each row that needs the extended cost, but it just shows the formula in the field. I need the field to reflect the unitprice1 * itemcost1, not the formula. Any way to fix this? |
Thread Tools | |
Display Modes | |
|
|