Hi
I am new to access

I have created a report and the field list is pointed to an underlining table.
I need to create a few new text boxes, which data source is different from the field list. It is the result of some sum querys that I have written.

I have tried to use the expression builder in the control source of the text box, where I can see the query, to bind the text box to the query.

= name of query and calulated column
=[2006Debit]![SumOfcustomer_account]

but every time I try to add the query and open the report it ask me for a parameter value relating to the query.

Can any help?

Use DLookup, DSum or a subreport

The report should be based on a query. Add the tables / queries to the reports query, and select the required fields for the report. Then make the report with the wizard (which does the hard work) then tidy it to suit your needs.

Col