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

  • Thread starter Thread starter danijela.simunovic
  • Start date Start date
D

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
 
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
Click to expand...

Double click the join line in your query. The three options then displayed
should make your solution obvious.
 
Sorry for beeing so stupid but where is that join line? In the SQL
view? I cant find it!
 
Rick said:
Double click the join line in your query. The three options then
displayed should make your solution obvious.
Click to expand...

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