Average a column on query

O

oakridge

I have a repeating table that lists times for an operator to tune a
particular machine. I have a query that returns the tuning times for certain
machines based on certain dates.

I also want to have an average of those times. How can this be accomplished?

I have used the Avg function in the footer of the repeating table and also
outside of the table. However, it will only return an average for all like
machines in the table not a subset based on date parameters. If the query is
only showing the correct machines based on the date parameters, why does the
control for the average not adjust itself to do so. I do have that control
to refresh when the formuala is recalculated. However, I see no way to
retrigger the recalculation.

Infopath 2003, SP1, creating a form from a SQL database.
 
O

oakridge

Greg,

You are correct. If I return all data for a machine based on the dates that
appear on open of the form 1/1/2004 and 12/31/2020, the average calculates
correctly (this by the way is all of the data in the database. If I query on
any other subset, this could be dates, machine type, machine item number, or
machine tuner or combination thereof the average does not work correctly. How
can I accommodate for these in the formula for the Average?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Setting column width in a table with a macro is not working 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Create a chart from a table in word thats dynamic 0
DLookup in Continuous form 0
Format column widths from one table to a separate table on same page 1
table questions 0
query to show where no data in a stated column 0

Top