mysterious field "<>" from crosstab query

  • Thread starter Thread starter Wei
  • Start date Start date
W

Wei

I have the following crosstab:

TRANSFORM Sum([group coverage_EE].SumOfWritten_Exposure)
AS SumOfSumOfWritten_Exposure
SELECT [group coverage_EE].Reported_Year, [group
coverage_EE].Month_Booked, [group coverage_EE].Pol_Term
FROM [group coverage_EE]
GROUP BY [group coverage_EE].Reported_Year, [group
coverage_EE].Month_Booked, [group coverage_EE].Pol_Term
PIVOT [group coverage_EE].Cov_exposure;

After I run this query, there is a field "<>" after
Pol_Term. What is this "<>"?

This has happened to many of my queries, and I'm not sure
why...
please help...

Wei
 
I c...thanks a lot!

Wei
-----Original Message-----
This is the column for NULL values.
I have the following crosstab:

TRANSFORM Sum([group coverage_EE].SumOfWritten_Exposure)
AS SumOfSumOfWritten_Exposure
SELECT [group coverage_EE].Reported_Year, [group
coverage_EE].Month_Booked, [group coverage_EE].Pol_Term
FROM [group coverage_EE]
GROUP BY [group coverage_EE].Reported_Year, [group
coverage_EE].Month_Booked, [group coverage_EE].Pol_Term
PIVOT [group coverage_EE].Cov_exposure;

After I run this query, there is a field "<>" after
Pol_Term. What is this "<>"?

This has happened to many of my queries, and I'm not sure
why...
please help...

Wei
Click to expand...
.
Click to expand...
 
Back
Top