illusionek
Registered User.
- Local time
- Today, 08:27
- Joined
- Dec 31, 2013
- Messages
- 92
Hello
Can please someone point me in the right direction how to solve below problem?
I have below table in my database where I have different products, sale date and sale value
Product Name| Sale Date| Sale Value
Product 1| 10/05/16| 100
Product 2| 10/05/16| 150
Product 1| 11/05/16| 125
Product 2| 11/05/16| 135
I am trying now to convert above table into below where I have an additional column stating Previous Day Sale.
Any idea how to do it? I was playing with DLookUp but then I get value of first record in the entire table across regardless of date or product name. I also tried DSum but it did not work neither :banghead:
Product Name| Sale Date| Sale Value| Previous Day Sale
Product 1| 10/05/16| 100|
Product 2| 10/05/16| 150|
Product 1| 11/05/16| 125| 100
Product 2| 11/05/16| 135| 150
Can please someone point me in the right direction how to solve below problem?
I have below table in my database where I have different products, sale date and sale value
Product Name| Sale Date| Sale Value
Product 1| 10/05/16| 100
Product 2| 10/05/16| 150
Product 1| 11/05/16| 125
Product 2| 11/05/16| 135
I am trying now to convert above table into below where I have an additional column stating Previous Day Sale.
Any idea how to do it? I was playing with DLookUp but then I get value of first record in the entire table across regardless of date or product name. I also tried DSum but it did not work neither :banghead:
Product Name| Sale Date| Sale Value| Previous Day Sale
Product 1| 10/05/16| 100|
Product 2| 10/05/16| 150|
Product 1| 11/05/16| 125| 100
Product 2| 11/05/16| 135| 150