>I need to list all fields in DayTrans and link to Customer only to get
>the Address. Am I right to code as:
>
>SELECT DayTrans.CustCode, DayTrans.CustName, Customer.Address
>FROM DayTrans INNER JOIN Customer
>ON DayTrans.CustCode = Customer.CustCode

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