Data Access Page

[Clois Beckwith]

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?

 

[Klatuu]

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.