Results 1 to 3 of 3
  1. #1
    jalb is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Jan 2012
    Location
    Florida
    Posts
    11

    Pull records only when a specific field are blank

    I would like to create a report that only pulls records that are assoiciated with a blank field.

    EX: I want to show all records that do not have a report received date entered

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You will need to create a query that pulls the records from the applicable table where the report received date field is null


    SELECT (fields you want)
    FROM YourTableName
    WHERE [ReportReceivedDateField] is null

    You will then base your report on the above query.

  3. #3
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    161
    A smal correction
    Above codwe pull only records where WHERE [ReportReceivedDateField] is null
    In case the the data is entered and later deleted in ReportReceivedDateField than these will not appear in report
    so use
    SELECT (fields you want)
    FROM YourTableName
    WHERE [ReportReceivedDateField] is null Or [ReportReceivedDateField] Like " "

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

Similar Threads

  1. Replies: 2
    Last Post: 05-08-2013, 03:37 AM
  2. Replies: 4
    Last Post: 05-11-2011, 03:06 AM
  3. Converting dates from a field with blank records
    By NOTLguy in forum Programming
    Replies: 3
    Last Post: 10-14-2010, 06:38 AM
  4. Code to pull in data from a specific record
    By jdunn36 in forum Access
    Replies: 1
    Last Post: 09-20-2010, 11:54 AM
  5. Add & Pull Records from Table via Form
    By sujitshukla in forum Programming
    Replies: 1
    Last Post: 08-02-2010, 05:51 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