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

[danijela.simunovic]

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

 

[Rick Brandt]

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.

 

[danijela.simunovic]

Sorry for beeing so stupid but where is that join line? In the SQL
view? I cant find it!

 

[danijela.simunovic]

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

 

[Rick Brandt]

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.