Advice please

[fargos99]

I have created a simple program that calculates cost and materials for a given suspended ceiling via a form.
Next I want to insert all the data from the fields on my form into a report and to carry out further calculations and add further details to the same report. Should I use VBA or Macros to do this and if so could you point me in the right direction or to an example of a similar application.

Many thanks.

Stu

 

[Jack Cowley]

There are a number of solutions to your question. You can, for example, create a query that is based on your table and do your additional calculations there then base your report on the query. You could also base your report on your table and so some calculations in unbound field in the report.