Recent content by markhan

Thanks for the answer. After some changes, finally ,the index seems to work and my queries have been speeded up. I cant reindex thats why i was asking about forcing indexes. thank you so much ;) Regads

Hi all! Lets see if someone could help me with this... Database: Access 2000 Indexes for log table: Ix(A,B,C,D) PrimaryKey(D,B,A,C) I cannot change the index, so I have to use those ones When im running this query: SELECT A,B,C,D FROM log WHERE A='a' AND B='b' AND C='c' AND (D<d1) AND E>=...

Thanks both for the replies :) The main program is a real time app updating a database each 5 secs. The application I have to do has to obtain data from the database and process it. Right now Im just using my app, the database is locally. Database: ACCESS 2000 Talking about the query: The...

Hi all! Well lets see if someone could help me a little bit and give me some guidelines about what can i do... Database: Access 2000 Rows: 1.8Millions LD = is a Date There are no relationships. The database is like this: SN GN VN LD LV LQ LA...

r937 You were close to the solution but probably we misunderstood each other. :/ sorry about that. I really appreciate all the time you spend to find the solution. Aswell i thought the solution of my problem was harder than i expected :/ In my #1 post i wrote this query SELECT l.SN, l.VN...

r937 Thanks for the help by the way i was showing the 2 select query i was using since the beginning ;P

Omg thanks a lot :((( (So much time wasted ¬¬) I didnt even need 2 selects :( Where were you PHV!! i needed you before!! haha just kidding ;) Thanks a lot This ends the question I just needed more group by...

Yep I tried the query with group by but it doesnt achieve all the conditions I need. with group by shows all the values for the minimun LDs each. I have 2 options: 1º Use 2 Selects (As right now) 2º Use a Self join? (Is this possible) If so is more efficient than 2 Selects?

:/ Ok... Sorry for the bad explanation. I need to check 3 conditions and from those conditions get the minimun value. So if i have this table: SN VN GV LD a a1 a2 1 a a2 a3 2 X Y Z 1 X Y Z 2 x b c 1 b b b 2 -------------- Conditions: SN = 'X' AND VN = 'Y'...

Thanks for the reply but that doesnt fit with what i want. I need to show in the query SN, VN, GV and LD. If i use the query you say It will only show LD value and i need all the values. IE. SN VN GV LD a a a 1 b b b 2 With your query the result it would be: LD 1 The result i need...

Hi all! I was wondering if someone could help me a little with this query. My intention is to use a Self join but i'm not transforming the query properly. Database: Access 2000 My actual query is like this: SELECT l.SN, l.VN, l.GN, l.LD FROM l WHERE (((l.SN)='X') AND ((l.VN)='Y') AND...