+ Reply to Thread
Results 1 to 3 of 3

Access Query shoes values and blanks in filter but no balnk records?!?!

  1. #1
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Access Query shoes values and blanks in filter but no balnk records?!?!

    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?!?!?

    Am fairly new to Access! Help!

  2. #2
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: Access Query shoes values and blanks in filter but no balnk records?!?!

    What criteria are you using for the blanks? If it's
    Please Login or Register  to view this content.
    Try
    Please Login or Register  to view this content.
    instead
    Frob first, tweak later

  3. #3
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Re: Access Query shoes values and blanks in filter but no balnk records?!?!

    I am not using anything for blanks as I don't want to see them.

    I have four fields. the first two have no creiteria, the 3rd is asking for "3132" and the 4th is asking for anything that Contains the string "*D&S*" or "*The Natural and Built Environment*"

    See attached....when I run the query the two columns with criteria show "3132" and (Blanks)......

    Access.jpg

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] access query design help - adding field while keeping all records
    By darpodo in forum Access Tables & Databases
    Replies: 9
    Last Post: 05-11-2016, 08:37 AM
  2. Replies: 1
    Last Post: 10-08-2015, 02:16 AM
  3. Looping through email body to include all records in query in Access.
    By SGT in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 09:39 AM
  4. Query Access database and return all records to Excel
    By bfs3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2014, 11:01 PM
  5. Access Table Query to Combine Records
    By smoothlarryhughes in forum Access Tables & Databases
    Replies: 4
    Last Post: 09-14-2012, 08:45 PM
  6. query filter didn't work in access 2007
    By already in forum Access Tables & Databases
    Replies: 2
    Last Post: 02-24-2010, 10:01 PM
  7. MS Access Query Identify Friday's records.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2006, 03:50 PM

Bookmarks

Posting Permissions

  • 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