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

T

Ted

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

Ideas?
 
E

Evi

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
 
T

Ted

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...
 
E

Evi

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
 

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

Top