Access Query shows (Blanks) but no blanks in data!
I am using Access as a quick way to manipulate and cleanse an excel spreadsheet.
To do this I want to run several queries to remove certain data and leave me with only the data I need to check.
The problem I seem to be having is that when I create my queries and run them the results for the columns I have set the criteria on show the values I expect but also shows (Blanks). When I filter for these blanks, however, there is nothing showing i.e. all the fields in my query are empty rather than just the column I filtered for the blanks.
Is this because there is a field in the source data that could be blank? I thought when you picked fields from a table to run a query only those fields are affected by the criteria - almost as if it's a mini data set. Am I missing something?!?!?
This is what the criteria has been set as:-
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By MissDB in forum Access Tables & Databases
Last Post: 09-08-2016, 05:47 AM
By hopegriffin in forum Excel Programming / VBA / Macros
Last Post: 07-20-2016, 10:51 AM
By lengwer in forum Excel Programming / VBA / Macros
Last Post: 10-05-2015, 09:13 AM
By luv2glyd in forum Excel Formulas & Functions
Last Post: 08-27-2014, 02:55 PM
By vemix in forum Excel General
Last Post: 10-17-2012, 01:17 AM
By D May in forum Excel Formulas & Functions
Last Post: 05-25-2006, 08:35 AM
By gsrosin in forum Excel General
Last Post: 02-22-2005, 12:06 AM
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1