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...
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.