Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Wink Unanswered: Easy access question?

    Hi All,

    I have an question related to Reports and Checkboxes in an access database.

    What I want is the following:

    When i check the checkbox in the form then I want the record to appear in a different report.

    I have checked google and such but was not able to find a similar issue and a solution for that. Perhaps you guys can help me out?

    Some information:

    Formname: invoeren
    Report1 name: probleem afgesloten
    Report2 name: probleem openstaand
    checkboxname: Call afgesloten

    I am not really a coder so I hope there is a simple way to achieve this

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    So you want one query for one report that gets those records with no tick and another query for a different report that gets those records with a tick? Where are you stuck?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Mar 2009
    Posts
    3
    Hi,

    Thanks for the reply.

    To be honest, allready stuck in creating a working query.

    I couldn't think of how to make the exception in the query where it defines whether the checkbox is true or false.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Mmmmnnn. In the Design Grid, there's a criteria row. Under you Yes/No column, specify True or False in that row.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Mar 2009
    Posts
    3
    Hi there,

    I found it and it works!

    Many thanks for the great support!

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're most welcome
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •