David Goldstraw
Last Activity: Jan 25 '11, 03:57 PM
Joined: Jan 20 '11
Location:
-
I had already indexed them but it didn't help, that was my first thought. The db is sat on a server which doesn't help. It seems to be working a treat now anyway so thanks eveyone -
Hi Code Green,
You certainly pointed me in the right direction. I have used the following which appears to give me my required result.
SELECT tbmaindata.URN, tbmaindata.Add1 , tbmaindata.post code, tbMainData1.URN , tbMainData1.Add 1, tbMainData1.pos tcode
FROM tbmaindata INNER JOIN tbMainData1 ON (tbmaindata.pos tcode) = tbMainData1.pos tcode AND (left(tbmaindat a.Add1,6)) = left(tbMainData 1.Add1,6);
...Leave a comment:
-
There are 13,026 in one and 1,505 in the other. it was taking 15+ mins.Leave a comment:
-
Hi Thanks for your reply, I have actually imported the table in to my main db and it is still slow. I will try your suggestion by linking the tablesLeave a comment:
-
How to fix Access Query that is running very slow?
I have two databases and I want to automate a process to find duplicates. I originally linked the table from one into the other but I have now gone down the route of importing the table from one db into the main one because it was running too slow.
Now I have imported the table I am still getting a very slow response from the query. I have tried numerous routes i.e. update, make table and even select and it is till slow. The query... -
How to call a dos variable in visual basic?
I would like to know how to call a variable I have set in ms-dos using e.g. set h=hello in visual basic. Can this be done?
No activity results to display
Leave a comment: