intervalmatch

[#1]

I have a problem with de combination orderdate per product and to combine the salesprice with the right costprice.

Example:

Tabel 1 :

product date from date till costprice

a 1-1-2010 28-2-2010 5,50

a 1-3-2010 20-3-2010 9,90

b 11-11-2009 18-2-2010 1,25

b 19-2-2010 31-3-2010 2,20

Tabel 2:

Order Orderdate Orderline product salesprice

98001 01-01-2010 1 a 12,50

98001 01-01-2010 2 b 5,90

98002 01-03-2010 1 a 15,50

IntervalMatch(orderdate) gives double records because there are more products per date selection.

Please can someone give me the right solution?

Thanks

[prieper]

Have a look into the extended syntax of the IntervalMatch

sample is attached (already joining the tables together i/o to avoid a synthetic key)

HTH
Peter

[#3]

Thanks Peter