I don't have much experience with Access but I am a web programmer who has been tasked with rewriting/converting an application developed in Access (lots of Forms, Queries, Reports and Macros) to a web-based application.
I've run into two reports which have the same Record Source but produce a different number of results.
I've compared thoroughly the properties of both reports and can't work out why the difference.
I'm sure there's some filters hidden away that I haven't been able to find.
Here's a capture of the report properties, which is identical for both.
[I couldn't post image due to being a new member, but Record Source is the same, Filter is blank, Filter On Load is No, Allow Filters is Yes]
I've also checked for any VB code for the report and there is none, and looked at the macro code that opens the report but can't see anything.
I'm hoping that an Access expert can point me in the right direction of where I might look for some filtering options I may have missed???
I've run into two reports which have the same Record Source but produce a different number of results.
I've compared thoroughly the properties of both reports and can't work out why the difference.
I'm sure there's some filters hidden away that I haven't been able to find.
Here's a capture of the report properties, which is identical for both.
[I couldn't post image due to being a new member, but Record Source is the same, Filter is blank, Filter On Load is No, Allow Filters is Yes]
I've also checked for any VB code for the report and there is none, and looked at the macro code that opens the report but can't see anything.
I'm hoping that an Access expert can point me in the right direction of where I might look for some filtering options I may have missed???