Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Thanked 0 Times in 0 Posts

    Outer Join (Access 2000)

    I have a query called qryBlStockFlow that calculates the difference between 2 other queries.
    I want however that my query qryBlStockFlow shows all the products from the first query
    called qryBlInputSum and not only the products that exist in the second query.In the cases when
    no substraction exists the fild should show 0.This is too complicated for me.
    I have tried to write RightJoin in the place where it is writtem LeftJoin, but i got an error
    and Access didnt accept my correction.

    My query is the folloiwng:
    SELECT qryBlInputSum.Productid AS ProductID, qryBlInputSum.grade AS grade, qryBlInputSum.size, qryBlInputSum.SumOfSumOfQuantity AS [In], qryBlOutputSum.SumOfQuantity AS Out, [SumOfSumOfQuantity]-[SumOfQuantity] AS balance, products.items2 AS [

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Outer Join (Access 2000)

    Try replacing INNER JOIN with RIGHT JOIN
    There must be a space between RIGHT and JOIN.

Posting Permissions

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