I
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,
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,