Results 1 to 2 of 2
  1. 12-09-2009, 06:19 AM #1
    Ize
    Ize is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    1

    E-mail query

    Hi People!



    I have a database with a members Register, and some members have an email registerd and some havent. I would like to make a query where the query shows only the ones who have a email. It doesnt work just to write "@" or something, I am really a newbie in this please help
    Reply With Quote Reply With Quote
  2. 12-09-2009, 09:47 AM #2
    SoftwareMatters
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    I take it if they don't have an email the field is left blank. If so, in the criteria put:

    Not Is Null
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Formatting E-mail Using Code
    By graviz in forum Programming
    Replies: 10
    Last Post: 12-10-2009, 10:10 AM
  2. E-mail Reports
    By Mike Cooper in forum Reports
    Replies: 2
    Last Post: 08-04-2008, 12:58 AM
  3. Mail merge
    By grgerhard in forum Forms
    Replies: 0
    Last Post: 04-25-2006, 05:06 PM
  4. Mail Merge problem
    By kfergus in forum Programming
    Replies: 0
    Last Post: 04-24-2006, 01:06 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums