Access Query

[ishwar.lakudzode]

Hello,


I have one problem while fetching record from database,
I required to take decision run time selection of query.
I have one field by which i can decide which query i want to execute and from both query i require ID but if i check it in loop then it take lot many time because i have 30,000 records so there is requirement of exicute 30,000 times that query so i can reduce it by provide all time exicution by providing one time ID to query but i am unable to get all ID using one query. and i can not exicute this queries two time because i want priserve order of record

Actully there is situation in which some time i get Instruction field and some time i get group if group is there then i need to search ID's of instruction which are inside that group and display that in sequence

Please help me..........

[June7]

Sorry, don't understand any of that description.

[ishwar.lakudzode]

I have one emloyee table and ID is primary key in it I am executing following query

Select * from employee where id IN(101,101,102,101);

I want record count 4 and four record in same sequence but i am geting only 2 records instead of 4 so please tell me how can i solve this problem

[orange]

Your IN statement only has 2 distinct values

IN(101,101,102,101)

You would only expect 2 records to be returned if the Employee ID is unique --

Employee ID 101 and Employee ID 102

Can you explain/describe what you are trying to achieve?

Did you mean to use IN(101,102,103,104) ?