one character fields name generated by crosstab query

[inungh]

I create a query base on a crosstab query.

The crosstab query has pivot clause like following:

PIVOT tblMytable.[MyGrade] In ("A", "B", "C", "D");

It generates single character filed name from pivot clause.

My problem is I need use (sum([a]) + sum())/ (sum([a]) + sum() +
sum([c]) + sum([d])) in my query.
It seems Access does not let me use single character field name.

If the filed name more than one character works fine.


any workaround?
Your information is great appreciated,

 

[KARL DEWEY]

Did your crosstab produce any nulls? Nulls do not sum very well.

 

[inungh]

Did your crosstab produce any nulls?    Nulls do not sum very well.
--
KARL DEWEY
Build a little - Test a little

I create a query base on a crosstab query.

The crosstab query has pivot clause like following:

PIVOT tblMytable.[MyGrade] In ("A", "B", "C", "D");

It generates single character filed name from pivot clause.

My problem is I need use (sum([a]) + sum())/ (sum([a]) + sum() +
sum([c]) + sum([d])) in my query.
It seems Access does not let me use single character field name.

If the filed name more than one character works fine.

any workaround?
Your information is great appreciated,- Hide quoted text -

- Show quoted text -

yes, it returns null value. does null value affect?
it works for more than one character field name.

Thanks again

 

[KARL DEWEY]

Use the Nz function like this ---
(sum(Nz([a],0)) + sum(Nz(,0)) / sum(Nz([a],0)) + .....
--
KARL DEWEY
Build a little - Test a little

Did your crosstab produce any nulls? Nulls do not sum very well.
--
KARL DEWEY
Build a little - Test a little

I create a query base on a crosstab query.

The crosstab query has pivot clause like following:

PIVOT tblMytable.[MyGrade] In ("A", "B", "C", "D");

It generates single character filed name from pivot clause.

My problem is I need use (sum([a]) + sum())/ (sum([a]) + sum() +
sum([c]) + sum([d])) in my query.
It seems Access does not let me use single character field name.

If the filed name more than one character works fine.

any workaround?
Your information is great appreciated,- Hide quoted text -

- Show quoted text -

yes, it returns null value. does null value affect?
it works for more than one character field name.

Thanks again