I have a report with a record source based on a query that has certain criteria that must be met in a particular field. However, this criteria is being ignored in 4 of the 5 reports. These five reports are similar except that they are dividing all the records up into the five separate reports based on this one field. The only one that is working, is the one whom's data is showing up on the other four reports.
Do I need to show more, or can anyone tell what is going on here? All five reports have their own separate record source.
I have a feeling I might have to explain more.