CrossTab Followup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The crosstab query I formulated had the start and end date in the parameter
list. However, when I tried to use the report wizard there were no available
fields listed. When I tried to use the AutoReport Tabular I received this
error: The Wizard was unable to generate fields from the record source you
chose. Perhaps you chose a query that doesn't return any fields.
Finally I tried to put dates in the crosstab query and remove the
parameters, make a report, then go change the query to put the paratmeters
back. Opening the report I had to put the parameters in twice - then was
given the error message The Microsoft Jet database engine does not recognize
" as a vaild field name or expression.
Thank you.
 
You should specify the column headings in the crosstab query properties. If
this doesn't work, come back the current sql view of your query.
 
Back
Top