Newlogiq

Hi CopperBackpack...thank you very much for your suggestions. In my case, I need to produce a report from that data set that shows only the most recent entry in the table for an order where an associated note is more than 5 days old. If there are 10 notes all older than 5 days associated with the order, I only want to show the order 1 time with the most recent entry. Please see the attached screen shot of the notes data table. Thoughts?

Hello...I need some guidance, please. I have a view of 2 tables. The first table contains customer information and an order number. The second table contains the order number plus a variety of notes associated with that order that have been date and time stamped. There are multiple notes entries for each order number. I'm trying to create a report that only shows the order number 1 time when a date from the second table matches some filtering criteria. Specifically, I want to only show those orders (again, just show order number 1 time) that do NOT have a note within XX days of today. How would you do this? I'm fairly new to Caspio...thank you.

Hello...I need some guidance, please. I have a view of 2 tables. The first table contains customer information and an order number. The second table contains the order number plus a variety of notes associated with that order that have been date and time stamped. There are multiple notes entries for each order number. I'm trying to create a report that only shows the order number 1 time when a date from the second table matches some filtering criteria. Specifically, I want to only show those orders (again, just show order number 1 time) that do NOT have a note within XX days of today. How would you do this? I'm fairly new to Caspio...thank you.