Skip to main content
Question

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

  • July 10, 2017
  • 0 replies
  • 17 views
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 
  
    This topic has been closed for replies.

    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".
    • SamKrausz
    • Author
    • Registered
    • July 10, 2017
    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?
    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.
    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.
    Terms & ConditionsAccessibility statement