0

Print View Problem - Select record if

Hi everyone,

I am trying to create a print report that shows a table view, but I can't get it to display the fields I want properly.

The table displayed is 'Shipping', and the fields shown below are showing correctly. However, I also want to display the column 'Journey' that shows whether the journey is a Collection or Return, and it will only show me the first, last, or concat. I want it to show the one that matches the date given. Any ideas please?

 

This is what I'm currently getting...

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 10 mths ago
    • Reported - view

    Hi Anna -

     

    Just a few questions:

     

    I could be wrong, it looks like Journey is a field in another related table to Shipping, what is that table name? What is the name of the reference field that links the table to Shipping?

     

    I'm guessing the Ship Date field is in the Shipping table is that correct?

    Like
Like Follow
  • 10 mths agoLast active
  • 1Replies
  • 123Views