I have built a database that utilizes a few different tables, "Customer List" and "Sales Orders. I am trying to build a query that will be used to make a report for some shipping data that will ultimately produce a the final Bill of Laden. Within my "Sales Order Table" I have the Fields that ask for Ship To Address, ect. I have built a side table that has a few fields for Bill To information for the freight cost. The Bill To information is dependent on (3) shipping method criteria which are inputed within a previous form. These methods are (1) Collect (2) Prepaid (3) Third Party. What I would like to do within a Bill of Laden Query is have the "Bill To" information field ask a IF THEN question such as the following. If [Billing Method]=Collect then [Bill To Name]= [Ship To Name]. My problem is that the above expression does not work...... I am new at this, please help.

Check out "IIF"

FYI, the correct term is "Bill of Lading".