CrossTab query to Report

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I'm using Access 2002 and have written a CrossTab query using variable
heading. The query will run and can be transferred with data to Excel or
Word; however, if I try to run a report from the query I get the error
message "The wizard was unable to generate fields from the record source you
chose. Perhaps you generated a query that doesn't return any fields." I can
see the fields and associated data when I run the query.
 
I'm still looking through your information so please bear with me. I have a
table with information in record #, year, month. I'm looking to create a
query where the user can enter a starting month and year. It's basically a
rolling report showing activity for 12 months beginning on the month and year
of choice. I was finally able to create a query that produced the results
but it will not convert to a report. Ideally it would be nice to use a
pivitol table but I run into the same problem of creating a report. Thanks
for your help, as mentioned I'll keep looking through your examples.
 
Back
Top