Can you create a report from a cross-tab query?

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

Whenever I try to do this, there are no fields to choose
from to add to my report.

Ideas?
 
You can just drag your query onto a blank report (just go to Report, New,
without selecting anything) to display it as an unbound subreport.

Would that be OK for you?

Evi
 
Yep...

I was trying to do it thru the wizard and it would never
show any fields to add on to the report. Followed your
suggestion and I think it will work.

Thanks...
 
I must warn you that if your column header is a date you will have problems
when you add or remove records. There are ways around this though, so write
back if this is the case and we'll hope that Duane Hookham, the Master of
the Crosstab, reads it :)
Evi
 
Nah, don't flatter him...it'll just go to his head. <g, d & r>
 
And I'll try to tackle my dyslexia and spell your name correctly next time
:)
Evi
 
I'll be leaving now and returning to Reports and Queries NGs ;-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross Tab Report Vs Dynamic coulmns 0
Can't create a report from my query in Access 1
Summing a text box on a report 3
Displaying a newly created field in a Query to a Report 1
Grand Totals in a cross-tab 1
report on a cross tab query 1
update cross tab query in a report 7
Pass infomration from a form to a report... 1

Back
Top