Crosstab Chart Error-Select a table or query with at least one numeric, date, or

  • Thread starter Thread starter MaggieMay
  • Start date Start date
M

MaggieMay

I have created a crosstab query and now I am trying to
make that as the source for a chart. When I do that I get
the following error: "Either the table or query you
selected doesn't have enough valid fields to provide data
for a chart or the fields can't be retrieved. Select a
table or query with at least one numeric, date, or text
field"
So I made a table by using the crosstab query and I can
create the chart from that table. I want the data to be
the latest data without having to have a temporary table.
Does anyone have any ideas?

Please help!
Maggie
 
Build your chart first using the table and then change the Row Source
property of the chart to the query.
 
Thanks! Seems kind of backward to do that way, but it is
a workaround that will keep me going.
Maggie
 
If your crosstab has used the Column Headings property, you should not have
to create a "temporary" table.
 
Back
Top