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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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 placed from our vendors 

This 2 tables are connected with a regular Table to Table relationship

Now, we need a report of produces which was order for the first time last week

We want to know all products which was order for the first time ever, during last week

How can this be done?

Thanks in advance for your help 
  
Photo of Sam Krausz

Sam Krausz

  • 470 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb
You have to bring the relevant fields from one table to the other table as "lookup" fields (in the relationship) and then create a report to show all the details needed by using the filtering option. And, I hope in one of your tables you save information about the "date of each order".
Photo of Sam Krausz

Sam Krausz

  • 470 Points 250 badge 2x thumb
I am looking to get when the item was first time ordered & only if it was ordered during last week then it should come up

How can this be done?
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
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.
Photo of Michelle

Michelle

  • 230 Points 100 badge 2x thumb
Is a new product added to the table in the same week it is first ordered? If so, you could make a summary report based off of the record's Date Created instead of creating a new field.