RE: Exclude zero-length strings in calculating average of a field
- From: "Ofer" <Ofer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 1 Sep 2005 15:13:02 -0700
Add a where statement to the query
Where Len(FieldName) > 0 and FieldName not is null
"Kathy Franklin" wrote:
> In Acccess 2003: I want to average individually 3 different payments fields
> by account, by year in a query in order to create a report based on it.
> During the current year some periods are of course zero-length strings
> because they haven't happened yet. When I try to average the payments the
> zero-length strings are counted as zeroes and skew the average (i.e., a
> quarterly account with two payments to date, as appropriate, is averaged over
> four quarters because the no-entry quarters are included in the calculation).
> I want an intentional zero payment to be counted, but not a blank.
.
- References:
- Exclude zero-length strings in calculating average of a field
- From: Kathy Franklin
- Exclude zero-length strings in calculating average of a field
- Prev by Date: Re: Difference between two dates
- Next by Date: Error message assistance needed!
- Previous by thread: Exclude zero-length strings in calculating average of a field
- Next by thread: Error message assistance needed!
- Index(es):
Relevant Pages
|
