Hello Everybody,
I would like To make a query that search a price from 2 criteria. If someone could help me please.
the table of cost price
Code:
DATE CODE Article Price
01/02/2011 codeA articleA 789,45
07/02/2011 codeA articleA 750,02
11/02/2011 codeA articleA 724,99
01/05/2011 codeA articleA 773,25
01/06/2011 codeA articleA 820,03
the query that will search for the first criteria 'codeA' and second criteria the date with is the closest date before the invoice date and display the cost price.
Code:
InvoiceDate CODE Article Price
05/02/2011 codeA articleA 789,45
15/02/2011 codeA articleA 724,99
01/05/2011 codeA articleA 773,25
18/06/2011 codeA articleA 820,03
thanks a lot for your help