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

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM

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
Thread Forum
Start, Computer reports 279 GB size |Disk Manager reports 1862 GB size
I have attached a Snip of each. Seems weird but Windows keeps reporting the Photo Volume as low on space. Is there a way to correct this and get the extra Gigs back? Best regards, Mike Lynch
Any problems using Access 2007 database with Access 2010?
According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes? So why do I have the feeling that something is not going to work? Is it because I have...
Microsoft Office
DIR 615 reports link at 300Mbps, windows reports 150Mbps
Hello there, Recently setup my home wifi network, i had been noticing that my link speed to any device through my Dlink DIR 615 router, was always 65Mbps (as reported by the device), i searched around that i should set the channel width to 'auto 20/40mhz' to gain speed; however now that i did...
Network & Sharing
access 2010 autonumber
hey there, for my work i need to create a database which will be filled with agreements we make with supliers. Now i want to make an autonumbering which looks like this "SLA0001". Is there a way for that? hope to hear from you soon DD
Microsoft Office
Access 2010
I hope this is not a stupid question guys but why does Access 2010 open a blank database with 2007?
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 22:30.
Twitter Facebook Google+