How do I get unbound control in report

[darrrellx]

I am trying to build an inventory report and am having problems. I have a field for units on hand which is a calculated field in an unbound control on my form.
When trying to add fields to my report with the report wizard, I don/t see this control anywhere to add it to the report. How can I get this on my report?

Thanks

darrellx

 

[ajetrumpet]

I would say the best way to get a calculated field into a report is to base your report off of a query that contains that field for every record you want to view. I assume you don't see it in the wizard because the field is not part of the recordset that your form is based off of. If you create a control on your form that is bound to a calculated field in your source table (should be a query), you will see it in the field list of the report wizard.

Try creating a query that contains the same fields as your source table and add a calculated "on hand) field to it. Then base your form and report off of that. This will create a bound form control.

 

[MStef]

Hello darrrellx!

Look at "DemoRptUnbConA2000.mdb".
1) Open Form1, there is an Unbound control. You can add this control
on a report, look at Report1 UnbControl (red colour).
2) Or, as Ajetrumpet suggest, via query.
Look at Query1, UnbCont column. It is on a report in blue colour.