Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 03-17-2011, 01:43 AM   #1
Newly Registered User
Join Date: Mar 2011
Posts: 18
Thanks: 4
Thanked 0 Times in 0 Posts
vancey is on a distinguished road
Qry To Exclude Record If All Fields On Page Is Blank Except Field "xx", "yy" And "zzz

Dear all,

Basically, i need a query to exclude all records ONLY if ALL selected fields are blank. (means if one of a field has a value, it still shows up, only all blanks will not show up).

I had a command button which opens up a new form for inputs like this:

stDocName = "frmEmployeesHIPO"
DoCmd.OpenForm stDocName, , , qryFilterBlankHipo

where what i did in the qryFilterBlankHipo is that i included all the fields in that form except 3 fields that are reused fields from 1st form (to display again the EmployeeID,name e.g.) , i built a query and added all fields except the 3, and in the Criteria, i tried Not Is Null, ="" in ALL of the fields in the same row but it does not work i wondered why.

Do i have to set filteron to true or something?

Attached is the Screenshot of the query.

Please guide me. Thanks a lot~

Attached Images
File Type: jpg untitled.JPG (22.1 KB, 160 views)

vancey is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What's the difference between the "Enabled" and "Locked" field properties? RSW Forms 4 11-16-2012 12:29 PM
Defaulting a "Medium Time" field to be "p.m." instead of "a.m."? Cobo Tables 4 04-26-2010 02:37 PM
"Record is deleted" and "Could not update, currently locked" Paddy1980 General 1 01-14-2010 03:36 PM
Help needed with "no corresponding record on the "one" side" error timofe Forms 4 02-25-2008 01:54 PM
Changing toolbar button setting from "Default Style" to "Image and Text" in VBA KeithWilliams Forms 0 10-20-2004 02:14 AM

All times are GMT -8. The time now is 02:28 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World