+ Reply to Thread
Results 1 to 3 of 3

Thread: [Solved] Ignoring Blanks in Access

  1. 08-20-2010, 09:54 AM #1
    crazysniper
    crazysniper is offline
    Registered User
    Join Date
    08-28-2009
    Location
    London
    MS-Off Ver
    Excel 2003, 2007
    Posts
    65

    [Solved] Ignoring Blanks in Access

    Hi Everyone,

    I created an append query in Access 2007 to gather the data from my source (an excel sheet) however it is copying the blank spaces. Does anyone know how can i tell access not append anything if the source is empty?

    Would really appreciate your help.

    Thanks in Advance.
    Last edited by crazysniper; 08-21-2010 at 07:34 PM.
    Reply With Quote Reply With Quote
  2. 08-20-2010, 11:27 AM #2
    split_atom18
    split_atom18 is offline
    Valued Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    270

    Re: Ignoring Blanks in Access

    Hi crazysniper,

    You want to put Not IsNull in the Criteria of the field you are appending.

    Hope this helps,

    Dan
    "I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
    If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
    Reply With Quote Reply With Quote
  3. 08-21-2010, 07:32 PM #3
    crazysniper
    crazysniper is offline
    Registered User
    Join Date
    08-28-2009
    Location
    London
    MS-Off Ver
    Excel 2003, 2007
    Posts
    65

    Re: Ignoring Blanks in Access

    Quote Originally Posted by split_atom18 View Post
    Hi crazysniper,

    You want to put Not IsNull in the Criteria of the field you are appending.

    Hope this helps,

    Dan
    wicked.

    thanks for your help dan.
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0