2 Different Date ranges in 1 report (without using subreport)

[cody91998]

I have a report that shows 3 months of actual data (based on user defined start and end dates from query) and I need to add 1 month of budget data to the same report but with a different date.



Example

Jan, Feb, March - Actual Data
March - Budget Data

The budget data will always be the end date of the actual data.

Hope this makes sense. Any suggestions?

[CJ_London]

Any suggestions?

not without knowing how your data is structured so some wild guesses

use a union query
and/or use a left join query
and/or modify your criteria