Discussions

Expand all | Collapse all

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

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

    Posted 07-10-2017 17:32
    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 
      


  • 2.  RE: Looking for a report of all items which we did ordered for the first time during last week

    Posted 07-10-2017 18:05
    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".


  • 3.  RE: Looking for a report of all items which we did ordered for the first time during last week

    Posted 07-10-2017 19:55
    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?


  • 4.  RE: Looking for a report of all items which we did ordered for the first time during last week

    Posted 07-10-2017 21:07
    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.


  • 5.  RE: Looking for a report of all items which we did ordered for the first time during last week

    Posted 07-12-2017 19:04
    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.