Avatar of amcpike
amcpike
 asked on

Query of Queries to Return Only Populated Fields in All Queries

Hi All,

This is likely going to be a confusing request, so I apologize. Here is an example of what I am trying to do:

Here are examples of fields in one table of my database:

-Note Number
-Name
-Corrected Name
-Name Correction Needed? (Y/N)
-Address
-Corrected Address
-Address Correction Needed? (Y/N)
-Phone Number
-Corrected Phone Number
-Phone Number Correction Needed? (Y/N)

I have built separate queries to return:
1) All Note Numbers where "Correction Needed" is True for Name
2) All Note Numbers where "Correction Needed" is True for Address
3) All Note Numbers where "Correction Needed" is True for Phone Number

Is there a way to build a query that would say:
For Note Number [Enter Note Number], show me only those fields where "Correction Needed" is True, presumably based on these queries but open to other suggestions.

So if there is a correction needed for Name and Address fields, but not Phone Number fields, I want to see in my query:
Note Number, Name, Corrected Name, Name Correction Needed (True), Address, Corrected Address, Address Correction Needed (True)

I don't want to see any Phone Number fields if there is no change required for that Note Number.

Is this possible?

Thanks,

Andrea
Microsoft Access

Avatar of undefined
Last Comment
PatHartman

8/22/2022 - Mon
SOLUTION
Walter Ritzel

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
PatHartman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61