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
Katsumoto

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
Irene

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 - Office.com
My System SpecsSystem Spec
26 May 2012   #3
Katsumoto

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
Irene

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 - Office.com
My System SpecsSystem Spec
27 May 2012   #5
bbinnard

Win7-64
 
 

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
Katsumoto

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
GEWB

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

Hello Katsumoto -

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

Regards,
GEWB
My System SpecsSystem Spec
Reply

 Access 2010 - Reports...




Thread Tools





Similar help and support threads
Thread Forum
Access 2003/2010 fix.
I have a corrupted mdb access file 61Mbytes. There seems to be many paid for programme 'fixes' around that will repair and extract the data, I can do that. BUT I cannot see a program that will actually REPAIR the database so you can double click it and get the original programme to work. Anyone...
Microsoft Office
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
MicroSoft Access 2010 keeps crashing w/ W7
I have a simple document tracking database that I wrote in the late '80's and have migrated up through the newer versions of MS Access. Recently when I am editing a date entry form it will crash while I'm working. The error message is always similar in that only the "Exception Offset" changes. I...
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 07:54.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App