Crosstab Querry

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

When I try to create a report from a crosstab querry,
none of the query's fields are available for selection.
What might be the problem?

Thanks
 
When you build a report against a xtab query, the query is actually run to get the list of fields.

I'm guessing that you don't have any data coming out of the query, hence no fields.

You can do one of several things depending on the nature of the query.

1 - Make sure you have data coming out of the query. As xtab queries produce dynamic results, your report will break in the future
if any of the fields disappear.

2 - If the columns heads are predictable, like the 12 months of the year, you can set the Column Headings property of the query to
what you will have at various times. See help on this property.

3 - If the columns are not predictable, you can make a "dynamic" report. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;328320.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Thank you. With your help, I was able to create needed
reports.
-----Original Message-----
When you build a report against a xtab query, the query
Click to expand...
is actually run to get the list of fields.
I'm guessing that you don't have any data coming out of the query, hence no fields.

You can do one of several things depending on the nature of the query.

1 - Make sure you have data coming out of the query. As
Click to expand...
xtab queries produce dynamic results, your report will
break in the future
if any of the fields disappear.

2 - If the columns heads are predictable, like the 12
Click to expand...
months of the year, you can set the Column Headings
property of the query to
what you will have at various times. See help on this property.

3 - If the columns are not predictable, you can make a "dynamic" report. See
http://support.microsoft.com/default.aspx?scid=kb;en- us;328320.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

"Roy" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top