Using macro to open report based on empty field.

Discussion in 'Microsoft Access Macros' started by Ebbrecords, Apr 6, 2009.

  1. Ebbrecords

    Ebbrecords Guest

    I have a report to create that extracts data from different tables and will
    be generated with a macro. I want the data on the report to be based on if a
    field in a certain table (date field) is populated. If the field is empty,
    then I want that record (consisting of different fields in the different
    tables) to appear on the report. If the date field is populated, then I do
    not want them on the report.
     
    Ebbrecords, Apr 6, 2009
    #1
    1. Advertisements

  2. Ebbrecords,

    If I understand you correctly, the table that contains the date field in
    question is part of the query that the report is based on. In the Criteria
    of the date field in the query, enter:
    Is Null

    --
    Steve Schapel, Microsoft Access MVP


    "Ebbrecords" <> wrote in message
    news:...
    > I have a report to create that extracts data from different tables and
    > will
    > be generated with a macro. I want the data on the report to be based on
    > if a
    > field in a certain table (date field) is populated. If the field is
    > empty,
    > then I want that record (consisting of different fields in the different
    > tables) to appear on the report. If the date field is populated, then I
    > do
    > not want them on the report.
     
    Steve Schapel, Apr 7, 2009
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Steve Davis

    Macro to Update Field based on Info in Another Field

    Steve Davis, Jun 14, 2004, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    276
    Steve Schapel
    Jun 15, 2004
  2. Guest
    Replies:
    3
    Views:
    350
    Douglas J. Steele
    Jul 1, 2006
  3. Guest

    Run macro based on empty field in form

    Guest, Aug 31, 2006, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    210
    Steve Schapel
    Aug 31, 2006
  4. Dan Goble

    Macro to respond to Empty Field or Control

    Dan Goble, Mar 7, 2007, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    158
    Steve Schapel
    Mar 7, 2007
  5. noirorekab
    Replies:
    0
    Views:
    1,305
    noirorekab
    Sep 25, 2012
Loading...

Share This Page