tblProducts Table
tProductID Text - PK
tProductName Text
tblProductsPrice Table
tProductID Text - FK (VAlues will be like OJFDKERWER)
iProductDate DateTime
lProductNPrice Number Double
I am storing the values of the tables as below -
tblProducts
OJFDKERWER, AcerLaptop
WPTRWJWERK, HP Laptop
tblProductsPrice
OJFDKERWER, 01-Sep-15, 500
OJFDKERWER, 02-Sep-15, 500
OJFDKERWER, 03-Sep-15, 500
OJFDKERWER, 04-Sep-15, 525
OJFDKERWER, 05-Sep-15, 495
Suppose today is 05-Sep then the query should list the price change from previous day (only if lower than before)
Please suggest me the SQL query which will run in access 2013 (not in SQL Server)
Many Thanks