Crosstab query column disappear

[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

 

[Duane Hookom]

The column won't be generated unless:
- your data generates the value or
- you enter all possible column heading values in the
Column Headings property of the Crosstab

 

[Miling]

Thank you very mcuh!
l just check with the table again , and found not value within April to Jun,
that's why
the column Qty 2 cannot be disappear.

Thanks again!

Best regards,
Miling

The column won't be generated unless:
- your data generates the value or
- you enter all possible column heading values in the
Column Headings property of the Crosstab

 

[Miling]

Sorry , typo error, is column cannot be display.


Thank you very mcuh!
l just check with the table again , and found not value within April to Jun,
that's why
the column Qty 2 cannot be disappear.

Thanks again!

Best regards,
Miling

The column won't be generated unless:
- your data generates the value or
- you enter all possible column heading values in the
Column Headings property of the Crosstab

 

[Duane Hookom]

If you need the column to display, enter all column headings into the Column
Headings property of the crosstab query.

--
Duane Hookom
MS Access MVP
--

Sorry , typo error, is column cannot be display.


Thank you very mcuh!
l just check with the table again , and found not value within April to
Jun,
that's why
the column Qty 2 cannot be disappear.

Thanks again!

Best regards,
Miling

The column won't be generated unless:
- your data generates the value or
- you enter all possible column heading values in the
Column Headings property of the Crosstab

--
Duane Hookom
MS Access MVP
--

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