Results 1 to 6 of 6
  1. #1
    mathanraj76 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    39

    data extraction for overseas

    hi..
    I need help..



    I have database
    inside my database i have query "Overseas"
    Inside my query table i have fields name "zipcode"

    My zipcode maximum number of digit is "6"

    if my zipcode number of digit is "< then 6" then
    ms access create a table and name as "zipcode error" extract the data and store into table "overseas zipode error"

    if my zipcode number of digit is empty then extarct this data and store into "overseas no zipcode"



    Thanks
    Mathanraj

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why do you need to put records in separate tables? You can just do a query to pull the records that don't have proper zip code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mathanraj76 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    39
    can you give me an idea

    i don't know how to do it..

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Try:

    SELECT * FROM table WHERE Len([zipcode])<6 Or IsNull([zipcode]);
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    mathanraj76 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    39
    thanks

    In my zipcode there no zipcode and it's blank or empty

    how should i use the sql code

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The suggested query should return all records where the zipcode is null or length is less than 6. Now edit the records to correct the zipcodes, if you want to.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-21-2011, 02:11 PM
  2. Data Extraction/update
    By Steven.Allman in forum Queries
    Replies: 4
    Last Post: 02-24-2011, 02:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums