How to calc values from table and then display in textbox

[Ben2k]

Lets say I have this simple table

Code Value

A 500
B 600
C 400

I have a form (or a report) with a text control.

When the form/report opens I want the total of the value column in the text control.

Thanks

Ben

 

[Joe4]

Re: How to calc values from table and then display in textbo

If your field is actually named "Value", then insert a Text Box in the Report Footer of your report and in the Control Source of the Text Box enter the formula:

=Sum([Value])

 

[Ben2k]

Re: How to calc values from table and then display in textbo

Okay thanks, what would happen though if there were two tables, both with a value field?

How could I refer to a specific field in a specific table?

Thanks

 

[Joe4]

Re: How to calc values from table and then display in textbo

A report can only be run of one table, or one query. So if you wanted a report that had information from two tables, you would need to link the data from the two tables in a query and use the query as the control source of your report.

Now, if you have a field name that exists in both tables, you simply need to specify which table in the calculation, i.e.
=Sum([Table1]![Value])

 

[Ben2k]

Re: How to calc values from table and then display in textbo

Thanks,

Can a form contain data from more than one table or query?

Ben

 

[Joe4]

Re: How to calc values from table and then display in textbo

As I said in my last post, a report can only be run from one table, or one query. However, that is really not a limiting factor, because you can combine an unlimited amount of tables and queries in a query.

If you have two tables, simply link the two tables together in a query, and then use this query as the Control Source for your report.