Hi,

i'm creating a form which should use 2 sheets to display actual price
for each services.

for that i have 2 sheets "services" and "services_price"
in "services" sheet, i have:

id Service Activated
1 S1 - Storage Y
2 S2 - Email Y
3 S3 - Internet Y
4 S4 - Intranet Y
5 S5 - mass printing N
6 S6 - Installation PC Y

in "services_price", i have:

id Starting date Ending date price
1 01.01.2010 31.12.2010 15.00
1 01.01.2009 31.12.2010 17.50
3 01.01.2010 31.07.2010 5.00
4 01.01.2009 31.12.9999 50.00
5 01.01.2009 31.08.2009 20.00
5 01.09.2009 31.12.2010 15.00

Is there a way to do something like select with union on ID field ?
because i would like to get only:
- activated services with a valid period.

thanks a lot,

A.