>>Since you need all field from one of the table, you could also write:
>>SELECT DayTrans.*, Customer.Address
>>FROM DayTrans INNER JOIN Customer
>>ON DayTrans.CustCode = Customer.CustCode
>
>Am I right to say that the SQL Statement will return all rows from
>the DayTrans table and cross reference (using the CustCode key) to
>Customer and return only the Address if found? Thanks.

Yes, but note that because this is an INNER JOIN orphaned DayTrans records will *not* be included. (That is, any DayTrans record with a CustCode keys that cannot be found in the Customer table will not be included.)