Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Forcing display of empty cells

Discussion in 'Information Technology' started by tomeck, Jul 28, 2006.

  1. tomeck

    tomeck
    Expand Collapse
    Guest

    I have a datatable that collects how people responded to a question (scale of
    1 to 30) from various states. What I want to do is to create a report by
    state of how each person answered the question, grouped by response. That is
    easy. What else I want to do is to create a report or query that displays a
    possible response, say 22, even if no one in a particular state entered that
    response.

    I tried creating a table with all possible options (1 to 30) and joining
    that to the datatable. I set the join properties of the options table to
    indicate that all entries in it must be used, but still an empty cell.

    Any ideas?
     
  2. Loading...

    Similar Threads Forum Date
    Pacific Oz School Apologizes for Forcing Sikh Boy to Shave Breaking News Jul 15, 2011
    Heritage Sikh Artwork On Display At Texas University History of Sikhism Mar 6, 2015
    UK Sikh Turbans on display at Bradford exhibition Breaking News Mar 1, 2014
    History Rare photographs’ display: Sikh community and culture presented in vibrant colour Punjab, Punjabi, Punjabiyat Dec 8, 2013
    Events Manuscripts on display at National Museum of Pakistan. History of Sikhism Mar 3, 2013

  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    create a query that associates all the questions with to
    OneToThirty table

    field --> QuestionID
    table --> Questions

    field --> Response
    table --> OneToThirty

    Since you want ALL the values from both tables, do not use a
    join line, simply put the fieldlists on the query with no joins.

    then, use THIS query to show all values from. Link to the
    questions from this query and link to the Responses from
    this query -- here is where you use outer joins.

    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    tomeck wrote:
    > I have a datatable that collects how people responded to a question (scale of
    > 1 to 30) from various states. What I want to do is to create a report by
    > state of how each person answered the question, grouped by response. That is
    > easy. What else I want to do is to create a report or query that displays a
    > possible response, say 22, even if no one in a particular state entered that
    > response.
    >
    > I tried creating a table with all possible options (1 to 30) and joining
    > that to the datatable. I set the join properties of the options table to
    > indicate that all entries in it must be used, but still an empty cell.
    >
    > Any ideas?
     
  4. tomeck

    tomeck
    Expand Collapse
    Guest

    Thanks. This works great!

    "strive4peace" wrote:

    > create a query that associates all the questions with to
    > OneToThirty table
    >
    > field --> QuestionID
    > table --> Questions
    >
    > field --> Response
    > table --> OneToThirty
    >
    > Since you want ALL the values from both tables, do not use a
    > join line, simply put the fieldlists on the query with no joins.
    >
    > then, use THIS query to show all values from. Link to the
    > questions from this query and link to the Responses from
    > this query -- here is where you use outer joins.
    >
    > Warm Regards,
    > Crystal
    > Microsoft Access MVP 2006
    >
    > *
    > Have an awesome day ;)
    >
    > remote programming and training
    > strive4peace2006 at yahoo.com
    >
    > *
    >
    > tomeck wrote:
    > > I have a datatable that collects how people responded to a question (scale of
    > > 1 to 30) from various states. What I want to do is to create a report by
    > > state of how each person answered the question, grouped by response. That is
    > > easy. What else I want to do is to create a report or query that displays a
    > > possible response, say 22, even if no one in a particular state entered that
    > > response.
    > >
    > > I tried creating a table with all possible options (1 to 30) and joining
    > > that to the datatable. I set the join properties of the options table to
    > > indicate that all entries in it must be used, but still an empty cell.
    > >
    > > Any ideas?

    >
     
  5. strive4peace

    strive4peace
    Expand Collapse
    Guest

    you're welcome ;) happy to help

    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    tomeck wrote:
    > Thanks. This works great!
    >
    > "strive4peace" wrote:
    >
    >
    >>create a query that associates all the questions with to
    >>OneToThirty table
    >>
    >>field --> QuestionID
    >>table --> Questions
    >>
    >>field --> Response
    >>table --> OneToThirty
    >>
    >>Since you want ALL the values from both tables, do not use a
    >>join line, simply put the fieldlists on the query with no joins.
    >>
    >>then, use THIS query to show all values from. Link to the
    >>questions from this query and link to the Responses from
    >>this query -- here is where you use outer joins.
    >>
    >>Warm Regards,
    >>Crystal
    >>Microsoft Access MVP 2006
    >>
    >> *
    >> Have an awesome day ;)
    >>
    >> remote programming and training
    >> strive4peace2006 at yahoo.com
    >>
    >> *
    >>
    >>tomeck wrote:
    >>
    >>>I have a datatable that collects how people responded to a question (scale of
    >>>1 to 30) from various states. What I want to do is to create a report by
    >>>state of how each person answered the question, grouped by response. That is
    >>>easy. What else I want to do is to create a report or query that displays a
    >>>possible response, say 22, even if no one in a particular state entered that
    >>>response.
    >>>
    >>>I tried creating a table with all possible options (1 to 30) and joining
    >>>that to the datatable. I set the join properties of the options table to
    >>>indicate that all entries in it must be used, but still an empty cell.
    >>>
    >>>Any ideas?

    >>
     

Share This Page