By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

No fields selectable for report

P: n/a
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
Jan 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

Jan 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.