Hi all,

I am trying to add {Supplier1.Name} to my report and it works BUT... all the orders that bah been landed in to my system without Supplier Name are gone and not showing on my report.
can I use a formula to replace blank fields with "N/A" for example?

Please HELP. And many thanks in advance.

** NEVER TOO LATE TO LEARN SOMETHING NEW **

Thanks for that.
I have tried it, but it didn't fix my problem.

My first column is {Putaway1.PutawayNum} from 1 to Max given by system:
1   Customer ref ProductName RotationNO location items
2   Customer ref ProductName RotationNO location items
3   Customer ref ProductName RotationNO location items
4   Customer ref ProductName RotationNO location items
5   Customer ref ProductName RotationNO location items
About 2000 lines

If I add {Supplier1.Name} or your formula I can't see all the order?!?

Have I linked some tables incorrectly or any other ideas?

Ta

Hi Rahul, thanks for your reply.

I am a bit lost: you asked "are you doing inner join or left joins"? I do not understand.
And how can I pull out "sample date"?
I am very sorry but I am very very new to this.

Thanks for your patience. :)