Any way to get a total to show when filtering a query

[tagteam]

I have a query that just shows all the records in a table. It is used by the end user for filtering primarily. Now the user would like to see a total for the amount filtered.

For example; the table is for repairs. The query just shows ALL the repairs. The user filters the client field to find all repairs for one client. He then wants to see what the total charges are for that query.

I cant create a new field and sum the records because it is not a totals query. Is there any way to embed the query in a form and use the form portion to sum the filtered results?

[June7]

Users should not work directly with tables and queries, just forms and reports. Forms and reports can be used to show aggregate calcs.

However, a total row in table or query can be revealed by clicking the Totals button from ribbon. Select the desired aggregate function below appropriate field.

[tagteam]

Ok, that does not work the way I want it to. I also tried to create a form that was worksheet but when you do you cant use the header or footer of the form for any calculated fields.

I did get it to work by creating the query and then creating a multiple items type of form and i can then create the calculated field in the footer. it does not have the standard filter ability built into the cells like a worksheet but you can click in the field and do the filter.

[June7]

So you used a Continuous view form and arranged controls to look like Datasheet?

If you must have Datasheet then it can be a subform on another form. Textbox on main form can reference textbox in subform footer (it is there even though it won't show).

[tagteam]

Oh, yes, that is a better way. I created a worksheet form. added an unbound field to the page footer that did a sum calculation. Then added it as a subform on another form and referenced that subfield on the main form. works great and gives me the worksheet look and filter style I was looking for.

Thank you June7 that is very helpful