Exclude zero-length strings in calculating average of a field
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.
.
Relevant Pages
- Re: Does anyone offer reasonably simple/cheap on-line dollar payments?
... Firstly I had to setup an account with XE. ... But it was a one time deal to get an account and cost nothing other than a little time. ... After that I setup the details of the account/s I would be paying into, including details such as, Beneficiary's name, Name of bank, Account Number, Transit number, Bank address, Type of Currency. ... I have also made a couple of payments to other countires such as Denmark. ...
(uk.finance) - Fifteen Billion Dollars in in Pentagon Iraq spending unaccounted for
... The Pentagon cannot account for nearly 15 billion dollars in payments ... inspector general report. ...
(soc.retirement) - 15 bln dlrs in US Iraq spending unaccounted for
... WASHINGTON - The Pentagon cannot account for nearly 15 billion dollars in payments for goods and services in Iraq, according to an internal audit which members of Congress blasted Friday as a "shocking" accountability failure. ... Another five billion dollars spent on supporting the Iraqi security forces could not be properly traced, according to a November 2007 inspector general report. ...
(rec.aviation.military) - Re: Orange - Incorrect Credit File Entries
... notice for one and ii) it was registered after the account was completely ... Anyone that the credit reference agencies will listen to can register a ... September - January (5 payments) as I wasnt receiving any invoices or bills ... making the Montlhy Payments to the debt collectors. ...
(uk.legal) - Re: Accounting Reports in Access
... this was an Excel sheet. ... This is linked to the main information table using the account number ... you could build a report that groups by teach organization. ... I would then build a sub report that sums up all of the payments made by ...
(microsoft.public.access.reports) |
|
