Re: Access/Excel discrepancy

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Lake (tlake_at_twcny.rr.com)
Date: 01/14/05


Date: Fri, 14 Jan 2005 06:35:22 -0500


> Is there any differences between Excel's AVERAGE() and Access's Avg()
> functions?

If there are null values in the data (not 0), perhaps Access calculates the
average differently than Excel.

Tom Lake