Sum in a form field

[mig144]

I have made some queries in which there is a field which uses the Sum function.

I want to make a form which has text boxes in it, each of which shows this sum (the results of the sum). I don't know how to build expressions.

If I create a form using design view, and make text boxes, I go to the properties for the text box, in the control source, what expression do I put in there?

Can I have different text boxes on the same form, each with control sources of different queries?

Mrs Miggins.

 

[reclusivemonkey]

If you have created a query which has a sum in it, when you link this to a form, it will have the same result in. If you want to sum on a form, simply use =SUM([field_name]) in the form footer.

 

[jaydwest]

Is the form bound to a table, or a query, or is it not bound to anything?

 

[mig144]

I've found that if I bind the form to the query, then it does work for just that one query. But I want the answers to many queries on the same form, eg, text box 1 = "number of paladins in chambers"
box 2 = "number of paladins outside"
box 3 = "number of bins too big for chambers"
box 4 = "number of eurobins outside"

 

[Rich]

Why do you have so many queries? If your db is correctly designed a Totals query will give the results you want