Search query problem Access2007

[vaskoemilov]

Hello,
Fisrt i want to say that i'm novice here and in Access.

The main idea is to extract all cell from chosen RNC which KPI is below or above selected value.

I have the following issue:
dhttp_://imageshack.us/photo/my-images/818/accessquery.png/

As seen on the picture i want to create a query based on several criteria:
RNC, date, KPI, criteria C1 or C2

Have no problems with RNC and Date. Created a query containing all needed values for KPI criteria (for the drop down menu) but i dont know how to extract the selected value in BSC form from UMTS_Main_KPI and also to apply c1(more than) or c2(less than) criteria

I will apreciate all help which you can give me.
P.S. I'm not good at VBA at all.

 

[Guus2005]

i am not sure what you are asking. what is the problem?
please create a sample database describing the problem.

 

[vaskoemilov]

here is the example DB
the question is how to get only CSSR PS(or RRS setup) value(s) from TABLE in the RESULT query based on selections in boxes BSC.C and BSC.D1(or BSC.D2) in form BSC.

 

[Guus2005]

sorry i haven't been able to look at your database. on this laptop i have 2003 installed. so i can't read the database
you'll have to be patient or post a 2003 version.

 

[vaskoemilov]

Not a problem. This is not an urgent matter so I will be thankfull to look at it when you have spare time
Here's the 2003 version.