Results 1 to 2 of 2
  1. #1
    Nancy47B is offline Novice
    Windows 8 Access 2007
    Join Date
    Nov 2014
    Posts
    1

    Query to not pull address data if e-mail field exist.

    I need to create a query to pull ADDRESS fields info for mailing labels if the E-MAIL field is not empty. In other words, pull label info for only those with no email.

    I'm a total beginner at this.

  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,973
    That seems like a contradictory statement. First you say pull data only if the Email field IS NOT empty then you say to pull info if it IS empty.
    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. How do I pull address from table onto my report
    By tanyapeila in forum Reports
    Replies: 19
    Last Post: 03-26-2014, 01:53 PM
  2. Need to pull address from first record selected
    By tanyapeila in forum Queries
    Replies: 7
    Last Post: 03-17-2014, 02:55 PM
  3. Replies: 2
    Last Post: 03-07-2013, 04:50 PM
  4. Replies: 1
    Last Post: 11-10-2012, 09:13 AM
  5. Replies: 1
    Last Post: 08-22-2006, 04:27 AM

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