no access to other fields using join

J

jimbo jenkins

Is it possible to access the other fields of the "right" table o
records when using a left outer join?

Here's the original posting:
http://www.msaccessforum.com/t67922-s

I've have the number of records that i want now, but using the joi
seems to have cut off my ability to access the other fields i
DB_Checkouts. I'm trying to use info in that table to create new field
in the query with statements like
Status: IIf(IsNull([this_field]),"bad","good")

any ideas
 
Top