Mulitple queries in dynamic report gives last record data only

[bccoffee]

I have daily orders, monthly payments, and other charges. Very simply I want a monthly summary of charges and payments per customer. I have built 3 crosstab queries with the summaries and attemped to build a report, using the orders query and opening the recordsets of the other two queries.

Of course the orders are perfect, Access did that! I can see where I read each query recordset for payments, the values are different and correct in Detail_format. BUT when the report displays, I have the LAST RECORD's data for ALL customers. What is going on behind the scenes that I have missed? Yes, I am new at this...

I movenext properly, I can see that. I have movefirst in the reportheader_format event. any hints would be appreciated.

ALso tried combining the queries into one, but since each customer doesn't include entries in all the tables, I don't get all the information. Maybe we start here?

Thank you. I have tried everything I can think of, and have successfully built dynamic reports with recordsets before..??

 

[dhookom]

[blue]but since each customer doesn't include entries in all the tables, I don't get all the information.[/blue]
You can create queries that include all the records from one "source" and only matching from the other "source". You can view the join properties and set them according to your needs.

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]

 

[bccoffee]

Thank you! Just the hint to get my mind working again. (I should have asked earlier!) All fixed and working! Thanks again!