Forum Discussion

SamKrausz's avatar
SamKrausz
Qrew Cadet
9 years ago

Looking for a report of all items which we did ordered for the first time during last week

I have a Master table with a lot of products, every record is a new product, we are adding a lot of products each week into this table. Then we have another Details table with all the orders we did...
App builders
Relationships
reports and charts
MichaelBarrow's avatar
MichaelBarrow
Qrew Cadet
9 years ago
Create a Summary field in the Products table in the relationship and call it [Earliest Order Date] and make it the Minimum Date from the Details table. Then, you can use this date to filter in your report.