Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show Data even if one of field is null

Status
Not open for further replies.

cbiker

Programmer
Jul 2, 2003
35
US
I have a qry that uses 3 tables linked by date to get info for a report but in the loads table there are days that there arent loads taken out how do i get it to show the rest of the data on those dates. now it just leaves those dayes out of the report but I still need it to show them. Any and all help will be appreciated.
 
Try changing your join type to a left or right outer join.


-Gary
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top