Access Data Query

[Neerja]

I am trying to put 3 or more data bases.
For example:- one item sells today but tomorrow does not sell but I need
that item # with "Value 0"
How can I print report where I need to show different Quantity from
different days. and then at the end of week, I can total them.
Please help me...

Thank you,

 

[Duane Hookom]

I think you will need to create a query with a left or right join. For
instance a query from the Northwind sample MDB that includes all Products
whether or not they are in the Order Details table would be like:

SELECT Products.ProductName, Sum(Nz([Quantity],0)) AS TotQty
FROM Products LEFT JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
GROUP BY Products.ProductName;