Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 sheets and a select
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 sheets and a select
I think we are going to need more information about what you are wanting in
order to help you. Please give us more details. What is considered to be a valid period? Are you wanting to collect rows, ranges, etc.? What are you wanting to do with the collections? -- Cheers, Ryan "Alain R." wrote: 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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 sheets and a select
baiscally i want (from an excel form) to call a SQL request which will
read data from the worksheets of the same workbook (where is the form). type of data is not so important. when i will know how to do that, i will later need to understand how in my SQL request i can link 2 worksheet data as i wrote before. is it clearer or do you still need more info ? thx. Al. On 08.02.2010 13:39, Ryan H wrote: I think we are going to need more information about what you are wanting in order to help you. Please give us more details. What is considered to be a valid period? Are you wanting to collect rows, ranges, etc.? What are you wanting to do with the collections? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheets.Select | Excel Programming | |||
select all sheets? | Excel Programming | |||
Select the same cell in sheets 2 & sheets 3 | Excel Programming | |||
sheets.select | Excel Programming | |||
select a1 on all sheets | Excel Programming |