I created report based on crosstab query by using a wizard. No problem. And I use text fields instead of label for column headers. BUT, the number of columns is not static. Every time when I try to open this report, I get message that one field is missing.

It is because this field was added after I created report. If I open query, I see this fiels and its header . Why I can't open my report . How to fix it.

I'd like to use recordset and create this report programmically.

Who knows how?
Please help me. This is very interesting
Thank you.
My e-mail addtess: tpk_k@********