Gary As far as I know, you need to calculate the averages in a query if you want to place the results in a table. I don't think you can do it from a report or a form. In the query you use the Avg function to calculate the average.
Thanks Liveson ----- Original Message ----- From: "gedaniels2003" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, 13 March, 2006 5:18 AM Subject: [ms_access] Calculated Fields - How to get the data? >I have created some calculated fields that appear at the end of a > Report, after the report footer. They all calculate averages by first > summing a desired field in all the records, then dividing by the > number of records (using "count(*)"). I have the same calculated > fields appearing at the bottom of each record when in Form View. I > need to know how to get the results of the calculations and have them > placed in a separate table or export them. Thanks in advance. > > Gary > > > > > > > > > > > Yahoo! Groups Links > > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
