How to show multiple records on form only if multiple records exist?

[duckster]

I have created a report for an underlying table. The underlying table records clients and their income for a certain year or years (in multiple records for client with multiple years).

For example, client 1 may show income of $20000 for 2005, and in their second record 2004, income of $10000.

I've created a report to show this information for each client based on a query; however, the report only shows income for one year (one record), i.e. only the 2005 year and income.

Does anyone know how I can get this report to list both records for the client, i.e. the 2005 year and income and the 2004 year and income right below it. So, for client with multiple records, it would show both years and their respective incomes, and for clients with only one record, it would only show one year.

Thanks !!!

 

[duckster]

When I run the query, it does list out multiple records for clients with multiple years. ... but I'm my report I'm not sure how to show the multiple years for clients with multiple years...

what i basically did with the report is drag and drop the "year" from the query's field list into the report design...this enables the report to show one tax year for each client, but not multiple years...

 

[rhesus_7]

Try adding a group header for each client. Or maybe your layout for each record is too close to each other that the succeeding records could no longer be seen.

 

[duckster]

I tried grouping the field year together in the report, but what the report will do is create an additional page for the same client if there are multiple years (with the same header on the 2nd page).

I want the multiple years to show up on the same page of the report if multiple years exist. I've tried putting the "keep together" option under the groups/sorting as "Whole Group"; however, the multiple years still do not show up side by side on the same page.