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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rancidmeat
-
SQL Query beyond my grasp
Rudy, Thanks. As far as my table having indexes? Duh! But wait I looked at the extract I brought home from and DOH! I did not add the indexes (only the tables at work have indexes - damn those AS400 extracts). ANyway after I re-indexed the tables and ran the Access utilities (Compact and Repair...- rancidmeat
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
SQL Query beyond my grasp
Rudy, I was unable to get it to work. I let it run for over two hours. I tried it on both the sample data and my live data. I did not get any errors. The query would just not complete.- rancidmeat
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
SQL Query beyond my grasp
I need help with doing the following: First here is the data Cust_ID Acct_Op_Dte Trans_Date Trans_Amt Store_Loc 12345 2004350 2004350 $160.00 4 12345 2004350 2004355 $160.00 4 54321 2004303 2004306 $0.07 1 54321...- rancidmeat
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
