Re: Microsoft Jet Engine does not recognize <> as valid name or ex
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Fri, 15 Dec 2006 16:27:55 -0500
Yeah, well I always have trouble with them myself. So I guess they are one
of my many weak points.
"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E9081B23-0C97-4004-97E1-0B6143FDACBE@xxxxxxxxxxxxxxxx
Thanks, John
I will admit that crosstab queries are a weak point for me.
"John Spencer" wrote:
A crosstab has [<>] as the null column if you pivot on a field that has
null
values in the query.
I suspect that the column that is causing the problem is this one
IIf(IsNull([BLANK %]),1,(1)-[BLANK %]) AS REPORTED
I'm not sure what you are expecting that calculation to do. It might be
that you want
[1] +[2] +[3] +[4] +[5] + [Y]/[Total of Emplid]
Or
1 - ( [<>]/[Total Of Emplid] )
SELECT [Rating by tier_Crosstab].Tier
, [Rating by tier_Crosstab].[Total Of Emplid]
, [<>]/[Total Of Emplid] AS [Blank %]
, [1]/[Total Of Emplid] AS [1's]
, [2]/[Total Of Emplid] AS [2's]
, [3]/[Total Of Emplid] AS [3's]
, [4]/[Total Of Emplid] AS [4's]
, [5]/[Total Of Emplid] AS [5's]
, [Y]/[Total Of Emplid] AS [Y's]
FROM [Rating by tier_Crosstab];
"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3E59A4E6-1D2F-4C15-B87E-6D3C046DA025@xxxxxxxxxxxxxxxx
You have it coded as if <> is the name of a field. Is that what it is?
"kswan" wrote:
I am trying to count the number of ee's by rating including if there
are
ee's
with no rating.
I keep getting an error due to my query looking for <>
Should this be written a different way?
SELECT [Rating by tier_Crosstab].Tier, [Rating by
tier_Crosstab].[Total
Of
Emplid], IIf(IsNull([BLANK %]),1,(1)-[BLANK %]) AS REPORTED,
[<>]/[Total
Of
Emplid] AS [Blank %], [1]/[Total Of Emplid] AS [1's], [2]/[Total Of
Emplid]
AS [2's], [3]/[Total Of Emplid] AS [3's], [4]/[Total Of Emplid] AS
[4's],
[5]/[Total Of Emplid] AS [5's], [Y]/[Total Of Emplid] AS [Y's]
FROM [Rating by tier_Crosstab];
.
- References:
- Re: Microsoft Jet Engine does not recognize <> as valid name or expres
- From: John Spencer
- Re: Microsoft Jet Engine does not recognize <> as valid name or expres
- Prev by Date: Re: Query Help Needed
- Next by Date: Re: Sequential Numbers
- Previous by thread: Re: Microsoft Jet Engine does not recognize <> as valid name or expres
- Next by thread: Re: concatenate and time
- Index(es):
Relevant Pages
|
