Hi,
I have a report (+ subreport) based on 2 DataTables.

In the detail section of the subreport (with a field "price") I want to calculate somthing for every record. This field is not a part of the DataTable. Depending of a value in a form I can write a function to calculate this (for example -> I make a function "extra cost" that does: price * form1.textbox1.text"

Now I have 2 big problems...
- How can I use form1.textbox1.value in my report? (do I have to pass it as a variable?)
- I can't make a sum of this function (in the report footer I need to calculate the sum of the function "extra function).

Can anybody help me, caus I really don't know where to start. In Access I bypassed this problem by making a table-make query. In this query I could refer to a function for every record calculating this. In the end, I used this new table to generate the report.