report containing two data sources

[bravo6]

I'm trying to create an income statement report where the report has two columns. The first column will be one dae range and the second column will be a different date range so that the user can compare income/expenses side-by-side. How can I use two different data sources in the same report? One source for each date range?

Thanks

 

[traingamer]

You might try two subreports (one for each column).

But you really haven't given us enough information. Is the information in the same table, but different rows? In different tables? Linked by user id?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[dhookom]

side-by-side" suggests there would be a common field. If this is true, combine both queries into a single query that joins on the common field.

As traingamer suggests, you haven't given us a lot to go on.

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]