M
Miling
Hi all,
Please kindly help me!
One of the crosstab query column was missing, the query should like this:
Ship name
Nature Item
Amount
Qtr
Qtr1
Qtr2
Qtr3
Qtr4
When l try to generate the quarter report, an error message prompt :
"The Mircosoft Jet database engine does not recognize '[Qtr 2]' as a valid
field name or expression."
Then l check the query and found the Qtr2 column was disappear. l have use
this mdb a few years,
so l check with the previous year (e.g 2005) mdb file, the SQL are same ,
but 2005's one query with
no problem.
Please kindly give me some suggestion how to get this Qtr2 column back!
Thanks and best regards,
Miling
Please kindly help me!
One of the crosstab query column was missing, the query should like this:
Ship name
Nature Item
Amount
Qtr
Qtr1
Qtr2
Qtr3
Qtr4
When l try to generate the quarter report, an error message prompt :
"The Mircosoft Jet database engine does not recognize '[Qtr 2]' as a valid
field name or expression."
Then l check the query and found the Qtr2 column was disappear. l have use
this mdb a few years,
so l check with the previous year (e.g 2005) mdb file, the SQL are same ,
but 2005's one query with
no problem.
Please kindly give me some suggestion how to get this Qtr2 column back!
Thanks and best regards,
Miling