Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Access 2010 - Reports...

25 May 2012   #1

Windows 7 Home Premium x64
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!

My System SpecsSystem Spec

26 May 2012   #2

Windows 7 Home Premium 64bit

Hi Katsumoto!

I personally don't use Access very much, but here is a guide which might give you some tips:
Create reports for a new database - Access -
My System SpecsSystem Spec
26 May 2012   #3

Windows 7 Home Premium x64

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
My System SpecsSystem Spec

27 May 2012   #4

Windows 7 Home Premium 64bit

Here is another MS Article about applying and saving filters in your reports - maybe that is the essence of the problem:
Apply a filter to view select records in an Access database - Access -
My System SpecsSystem Spec
27 May 2012   #5


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.
My System SpecsSystem Spec
28 May 2012   #6

Windows 7 Home Premium x64

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
My System SpecsSystem Spec
29 May 2012   #7

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux

Hello Katsumoto -

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

My System SpecsSystem Spec

 Access 2010 - Reports...

Thread Tools

Similar help and support threads for2: Access 2010 - Reports...
Thread Forum
Access 2003/2010 fix. Microsoft Office
Any problems using Access 2007 database with Access 2010? Microsoft Office
Solved DIR 615 reports link at 300Mbps, windows reports 150Mbps Network & Sharing
access 2010 autonumber Microsoft Office
Access 2010 Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:08 PM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33