Need formula to retrieve field that may be blank or not

[jlr123]

I need a better formula- Need to pull all data for those Ship Names that have items sold whether the items have serial nos or not.

The formula I have now:
IF isnull({AR_InvoiceHistoryLotSerial.LotSerialNo}) THEN "" ELSE {AR_InvoiceHistoryLotSerial.LotSerialNo}
Can you tell me what could be incorrect?

The rest of the data is:
Ship Name, Address, City, State, Zip, Qty,Vendor No, Item No, Serial No,(serial no if there is one)and unit price

 

[pmax9999]

What is wrong with that formula?


Pete

 

[jlr123]

It will not pull the data that has no serial number.

 

[jlr123]

I found my error was that I had an incorrect join between my tables. I had to select a left outer join from InvoicehistorylotserialNo to InvoiceHistoryDetail. Yea!!!!