Incomplete detail query data showing up in Access 97 subreport.

[bigdavidt]

I am working on an Access 97 report that displays financial information for clients. The detail section has a subreport object to display a list of transactions that took place during the last billing period. The master query and the detail query appear to work correctly; I can find the correct data when I open the queries in datasheet view. However, for a number of customers I cannot see complete transaction information when I open the report in the Preview window. What property settings should I look at first to try and resolve this problem?

For what it is worth, I had an earlier problem where detail information for some customers would be repeated two or three times.

 

[dhookom]

Check the link master/child properties.

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]

 

[CosmoKramer]

By "cannot see complete transaction information" do you mean you are missing some information, or get you none at all??

If it's missing info, you might want to check the Can Grow property for the subreport. It should be set to Yes.....

Si hoc legere scis, nimis eruditionis habes

 

[bigdavidt]

CosmoKramer, you hit it on the head. Thank you!