Report that prompts for dates - One item needs to start from a different date

[nigew]

Hi All

I have a YTD report where I have 7 sites sales data, split into 2 categories and a total. (Say 4/8/14 - 3/12/14)

One site only needs its total sales to be included from a certain date (Say 1/10/14)

I have created a separate query for the one sites total and joined it to my previous query and used in_range to select the start date of the one site.

This works ok as long as the report is run right upto date - however if the report is run for any dates before this it still shows the one sites sales from the start date through to now.

Any help would be appreciated.

Many thanks