all names not showing

  • Thread starter Thread starter linda
  • Start date Start date
L

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?
 
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
 
WOW--it worked!!!!! thank you so much

John Spencer said:
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
Click to expand...
 
Back
Top