Please Help!

[Geordie2008]

I have a cross tab query populated as follows

Country [as column]
Sales Person [as row]

I have used a query filter to filter the results based on Region, so the user can look at countries in a particular region

Because of this filter I now keep getting errors when the report opens as particular countries are no longer there.....

How do I prevent this?!?!?!

even if someone can just let me know if its something I'll have to find another way around.... It will stop me banging my head of my desk.

Thanks,
Mandy.

 

[Geordie2008]

Ah....

this seems to be beacuse the person is no longer in the "fields list" of the query I have generated based on the results from a form.

how do I get the report to auto-update for the new list of salespeople available? Or ignore the fact that some of them will not be returned by the query?

Thanks,