Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Forcing Index
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>=...- markhan
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
SQL long waits for the query
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...- markhan
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Access SQL query ---> SQL SelfJoin
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...- markhan
- Thread
- Replies: 12
- Forum: Microsoft: Access Queries and JET SQL
