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 TouchToneTommy 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 GoodFood
-
Query hangs, subquery runs fine..
That seems to work quite well right now. My only concern with that method is that the Transaction table is going to be growing pretty quickly.. the 25,000 records that I'm working with is one month's data. The transaction table in their current database (which I'm attempting to redesign)...- GoodFood
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
Query hangs, subquery runs fine..
Seems to run the same..- GoodFood
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Query hangs, subquery runs fine..
Thanks for your responses. I reduced my Transaction table to about 5,000 records, the subquery returns only 2 dup_ids, and the query took about 5 minutes to run when I was not doing anything else. That still seems like a really long time for the amount of data, but I guess it will eventually...- GoodFood
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Query hangs, subquery runs fine..
Hello- Using Access2000... I have a table of transactions that are imported from an external source. Here's the table structure: Transactions -transaction_id (PK) -cust_number -group_id -individual_id -individual_name -transaction_date In certain situations, there will be...- GoodFood
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
