all names not showing

[linda]

I'm trying to run a querie using 2 tables. One table has faculty names
including their budget amount. The second table has expenditures the faculty
have made. Some faculty have no expenditures yet. I want a query with
Faculty, Budget amount, Expenditures, and Balance. When I go for this, it
only gives me the faculty who do have expenditures. How do I get all names
and "0" for expenditures and the balance to equal the orginal budget?

 

[John Spencer]

In your query in design view, double click on the join line and then choose
the option that gives you ALL records in the Faculty table and only those from
the Expenditure table where ...

That should do it unless you are applying criteria against the Expenditure
table. If so, post the SQL of your query for specific suggestions on how to
modify it

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[linda]

WOW--it worked!!!!! thank you so much

In your query in design view, double click on the join line and then choose
the option that gives you ALL records in the Faculty table and only those from
the Expenditure table where ...

That should do it unless you are applying criteria against the Expenditure
table. If so, post the SQL of your query for specific suggestions on how to
modify it

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County