quarter problems?!?

[Guest]

Let me try to explain my problem.
I just create cross tab and he shows all expenses quarterly.
I create report based on inputs from that cross tab.
All inputs were, not correct ones, just for testing.
When delete data's Access show message like Microsoft Jet database engine
does not recognize "[qtr1]" as valid field name or expression..
I know why is that happening..But is there any way to override that problem
except to enter blank data and to move him by code from reports?
Maybe to define Column Heading in query with names Q1,Q2,Q3,Q4 and to define
those fields? Suggestion or solution will be highly appreciate..
THX

 

[Marshall Barton]

I just create cross tab and he shows all expenses quarterly.
I create report based on inputs from that cross tab.
All inputs were, not correct ones, just for testing.
When delete data's Access show message like Microsoft Jet database engine
does not recognize "[qtr1]" as valid field name or expression..
I know why is that happening..But is there any way to override that problem
except to enter blank data and to move him by code from reports?
Maybe to define Column Heading in query with names Q1,Q2,Q3,Q4 and to define
those fields?

Yes, set the crosstab query's ColumnHeadings property to
Q1,Q2,Q3,Q4

In SQL, it would be:
...
PIVOT ... IN("Q1","Q2","Q3","Q4")