Re: Count Function Ignores Null Values
- From: Lucifuge752 <Lucifuge752.1qp12a@>
- Date: Thu, 16 Jun 2005 01:28:34 +0100
I am trying to use a Query in Microsoft Excel to get information from
our Maximo database and some of the values NEEDED are the 0 or Null
values. Microsoft Query works like an abbreviated version of Access
but the Count(*) still ignores the null values even though the problem
was evidently addressed in Access.
Does anyone know a workaround in Microsoft Query or the best way to
have this type of query built into Excel? I am connecting to an Oracle
database and have had no problem getting the exact information I am
looking for the way I need it other than these Null values.
Thank you
--
Lucifuge752Posted from http://www.pcreview.co.uk/ newsgroup access
.
- Follow-Ups:
- Re: Count Function Ignores Null Values
- From: Klatuu
- Re: Count Function Ignores Null Values
- Prev by Date: Re: count fun returns with no data, how can i get it to return zer
- Next by Date: Re: English to Metric Update Query
- Previous by thread: I need help with the Round Function in Access. Is it me or Micros
- Next by thread: Re: Count Function Ignores Null Values
- Index(es):
Relevant Pages
|
