Hi All,

I'm running a report to look at staff attendance at meetings during a data period, the report is working fine for all department areas apart from one which doesn't show any data beyond 18/6/12 even though I know events and meetings for this department occurred after that date and I know people attended.

I'm using cross tab to show my data with the dates in the columns and the staff names in the rows and then the attendance type in fields. When I create a separate new report with just raw data no cross tab the dates continue beyond 18/6/12 so as I say I know there is more data.

I don't know why it's only this one department that won't work either, any brain waves gratefully received

Thanks