By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,930 Members | 1,321 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,930 IT Pros & Developers. It's quick & easy.

Queries in Access Trying to remove blank fields n preview fields with info only

P: 2
I made a query for my data some of it has gaps n the other have text but I want to only preview the fields with text not the empty ones. I trued sorting but that doesn't change the query. is there a certain criteria to use to remove blanks n only preview fields with info
May 16 '14 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,240
Josh3k,
Welcome to Bytes.com

Your question is not very clear. The more clear your question is the better the chance you'll get a good reply that solves your problem.

It's always a good idea to provide your code when possible. If you go into the SQL view of your query you can copy the query text and paste it into a post. Be sure to click the [CODE/] button and paste your code between the tags that appear.

Be clear about what you want. It sounds like some columns on some rows are blank and you don't want to see that. That's an odd request so maybe I misunderstand what you want. If all columns are blank or any combination of columns the whole row can be skipped. The only way to skip columns is to concatenate them all into one field, leaving out blank columns in the process.

Jim
May 16 '14 #2

Expert 100+
P: 1,240
Josh3k,
Please explain how you have solved the problem you had. Others will read this thread in the future and would like the benefit of your experience.

Jim
May 16 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.