Can I Display a Qry output as a Header Rows and then....

[rdjohnso]

Can I Display a Qry output as a Header Rows and then....
Cross-ref people against those header Rows...?

I have a master Email Distribution List (~15 diff lists)....
need to display those dynamically as headers (horizontally)
and then show the people as Rows and notate (x)
if each person belongs to that specific EmailList item.... like in a datasheet.

Any advise L/G?

Please advise,

R

 

[dhookom]

It sounds like a crosstab query might work. Could you take the time to provide
1) table and field names
2) sample records
3) desired output/display in your report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]