Access 2010 - Reports...

Hello all,

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!

Hello, Irene, and thank you for your reply :)

Having read through the link you have supplied in your post, I am, unfortunately, no closer to a solution. Both when creating the query and, subsequently, when creating the report, I go through the wizard route in the same way as it is explained in the link.

It's really done my head in - unless it is meant to revert to the whole database??

But, thanks again, Irene, I appreciate your assistance :)

In the example you give you have made a mistake. Tony Montana does not have blanks for the Attended and Paid fields, there are null values in those fields. Null means "no data" and is not the same as a blank, which is a valid character.

Your query can easily exclude Tony by using the "Not Null" criteria. This will find all the records with any value in the field but will exclude all records with no value.

Hello Irene and bbinard,

Well, aren't I the idiot of the forums today!

I had been totally forgetting to enter design view where, as you so correctly point out Birk, that I would need to fill in the criterion needed. And being checkboxes, I had to type 'yes'. I was searching for entirely the wrong thing the past few days, I just needed the refresher, it seems.

Birk, you're a genius! Thank you! You've saved me from a lot of angst

Hello Katsumoto -

If Birk has the answer, please mark the topic as SOLVED so others in the future can benefit!

Regards,
GEWB