display data from datasheet in report

[Bobnz]

how do I display the data from a datasheet subform in a report? the datasheet is base on a table.

B

 

[Bobnz]

I have created a query which does it but one row isn't displayed even though the query returns it ???

ie query returns 3 rows but in the list box on the report only 2 are shown

B

 

[dhookom]

You should create a report based on the same record source as your subform. I'm not sure what reason you might have for creating a List Box on a 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]
[blue]Ask me about my grandson, get a grand answer.[/blue]