I've searched and searched on the forums and on the web, but I have not found a solution to this possibly very trivial problem (or annoyance?).
At work, I've had to create a Report on attendance to a meeting, and another one on those who give their apologies.
E.g. On table
1) Joe Blogg. Attended. Paid.
2) Jane Citizen. Attended. Paid.
3) Tony Montana. [blank]. [blank]
Now, I'll proceed to make a query, and by default all three will be chosen, and so I have to manually unselect the third entry by clicking on (if I recall correctly) "all blanks". I will then save the query so that it shows only Joe and Jane in my query and from this proceed to create the desired report.
The report will show only Jane and Joe. I will print the report and everything is fine and dandy, will save and exit Access 2010.
This is where my problem comes up: let's say the next day I have to view the report again. I double click the desired report, but instead of showing Jane and Joe only, number 3, Tony Montana, is also included.
What am I doing wrong? I never had this problem in Access 2003, where I would need to re-create a report if I wanted to include Tony. Now, the whole database will show up as a report in an already saved report.
Any assistance will be greatly appreciated!