Welcome to SPN

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

Sign Up Now!

How to get all the data in a query...?

Discussion in 'Information Technology' started by danijela.simunovic@gmail.com, Oct 31, 2005.

Tags:
  1. danijela.simunovic@gmail.com

    Guest

    Hi again! I don't know how to pricesely ask this question but here is
    my problem.
    I have a tblMain and a tblSales. In the tblMain i have ID,Name,Price
    and in tblSales I only have ID(i have put it here as simples i could so
    that you could understand my problem). And now I have a qryTotal_Sales
    which has ID and the total quantity sold(takes data from tblSales). But
    if some thing wasn't sold it's ID doesn't appear in the qryTotal_Sales
    with total 0. Is there a way to get all the ID from the tblMain weather
    or not they were sold in the qryTotal_Sales?
    Thanks!

    Danijela
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    danijela.simunovic@gmail.com wrote:
    > Hi again! I don't know how to pricesely ask this question but here is
    > my problem.
    > I have a tblMain and a tblSales. In the tblMain i have ID,Name,Price
    > and in tblSales I only have ID(i have put it here as simples i could
    > so that you could understand my problem). And now I have a
    > qryTotal_Sales which has ID and the total quantity sold(takes data
    > from tblSales). But if some thing wasn't sold it's ID doesn't appear
    > in the qryTotal_Sales with total 0. Is there a way to get all the ID
    > from the tblMain weather or not they were sold in the qryTotal_Sales?
    > Thanks!
    >
    > Danijela


    Double click the join line in your query. The three options then displayed
    should make your solution obvious.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     
  4. danijela.simunovic@gmail.com

    Guest

    Sorry for beeing so stupid but where is that join line? In the SQL
    view? I cant find it!
     
  5. danijela.simunovic@gmail.com

    Guest

    It's the line beetwean two querys! I'm so stupid! Thanks a lot!!!
     
  6. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Rick Brandt wrote:
    > danijela.simunovic@gmail.com wrote:
    > > Hi again! I don't know how to pricesely ask this question but here
    > > is my problem.
    > > I have a tblMain and a tblSales. In the tblMain i have ID,Name,Price
    > > and in tblSales I only have ID(i have put it here as simples i could
    > > so that you could understand my problem). And now I have a
    > > qryTotal_Sales which has ID and the total quantity sold(takes data
    > > from tblSales). But if some thing wasn't sold it's ID doesn't appear
    > > in the qryTotal_Sales with total 0. Is there a way to get all the ID
    > > from the tblMain weather or not they were sold in the
    > > qryTotal_Sales? Thanks!
    > >
    > > Danijela

    >
    > Double click the join line in your query. The three options then
    > displayed should make your solution obvious.


    In the query design grid. You should see both tables with a line joining them.


    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     

Share This Page