No fields selectable for report

[RJS76 via AccessMonster.com]

Hi,

First of all, great site! It has helped me a lot.

I am trying to make a report based on a crosstab query. I want to use all the
fieldsin the query but when I select the query in the Report Wizard I cannot
select any fields in the Available Fields because I don't see any fields in
it.

Can somebody please help me with this? Thanks in advance!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200601/1

[Allen Browne]

When you create a crosstab query, the field names are generated dynamically
from the contents of Column Heading field. If you filter the report, the
number of fields can disappear.

You can solve that problem by listing all the possible values in the query's
Column Headings property. This ensures that the values are available for the
report, and it should help it to know the field names at design time too.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"RJS76 via AccessMonster.com" <u15953@uwe> wrote in message
news:59c3331f7cac2@uwe...

First of all, great site! It has helped me a lot.

I am trying to make a report based on a crosstab query. I want to use all
the
fieldsin the query but when I select the query in the Report Wizard I
cannot
select any fields in the Available Fields because I don't see any fields
in
it.

Can somebody please help me with this? Thanks in advance!