Search results

Nope, its just as slow, i guess it is gonna take a long time what ever, the tables i am using and hundred of thousands of records... oh well... a valiant effort all the same!! Look like this is gonna have to become an overnight job !!! Thanks Tim

I've just read about the filter property of the recordset, i think i should be able to save alot of time with this... i am just going to try! Thanks Tim

Hello Guys & Gals, I have function that gets called thousands of times throughout a process, the method i am currently using envolves opening and closing the recordset per interation. The reason i do this is because the criteria changes per time. Here is the code, i am a self taught coder so...

Cheers neil, i think i might just reimport the data trimming all the other characters out.

Hi, I have two tables i would like to create a relationship with but the two fields that i want to join are not exactly the same e.g Table 1 0000111111 Table 2 111111 ABC The key piece of information that i would like to link together is the 111111, in SQL i would just type "WHERE Code LIKE...

Excellent, thanks for your help there MStef, i did not think of using two inner joins. I have now created the query i needed, you saved me from the work around i was going to attempt and i really did not want to do that. Thanks for all your help. Kind regards Tim

Hi, I have tried a fee different methods but none of which are giving me exactly what i need, i was hoping some one out there might be able to suggest a good approach. I have the following data. Source ID , Product , Price , Count 1 , F2 , 10 , 6 1...

Thanks Brian, Your analysis of my tables is correct and this should give me another approach to try. Cheers. Tim

Here is a little sample of the query results. app_num, prod_code, app 00123, N5, 100 00123, L5, 110 what i am trying to achieve is for the query to basically retrieve only the bottom line of data because it has the greater app fee, any suggestions anyone...

Thanks for the response Brian, isnt "FROM a LEFT JOIN b ON a.prod_num = b.gsn" Just the same as what i was already doing though? "FROM table1 AS a LEFT JOIN table2 AS b ON a.prod_code = b.GSN" I think the issue may be the method i am using to the select the highest value, is there a different...

Hello all, I am having trouble creating a query, here is the query i am having issues with SELECT a.app_num, Max(b.app) AS Highest, a.prod_code FROM table1 AS a LEFT JOIN table2 AS b ON a.prod_code = b.GSN GROUP BY a.app_num, a.prod_code; Now the query above works fine with out the...

Thats an excellent suggestion, i have had a little play with using a union query but to no joy, you mention "Find non duplicates" in what context would you acheive this? Also to give you a little more infor on the layout, table1 is the main table with about 80000 records and table2 is the one...

Thanks Len, i have i just read the following arctile of which you had some input in also. http://www.access-programmers.co.uk/forums/showthread.php?t=88648&highlight=Normalisation The database i have created will not need normalisation because it is not used for manual input, basically we have...

Basically the problem is that a lot of information is imported into table2 daily and i need it to only update the information thats "reference" is in table one. i.e table2 reference must exist in table one for it to update, it it does not dont just add it, do nothing. I am not aware of...

Hi Guys, I have got a query that updates details from one table2 to table1, "Reference" is the primary key and this is what the query uses to determine which need updating. It all works great but if table2 contains a record in "Reference" that is not in table1 i just want it to ignore it...

Hello all, I am trying to write a query that deletes all records from one table that meet the criteria of another. The table i need to delete from is called StartingPoint and the other table is called R7e, both tables have a field called "Reference" and R7e has a field called "Change". I have...

Thanks for that, i will have a look into it now. Cheers Tim

Hello all, I have got two questions i would like to ask y'all. 1. I have created a data input form that feeds directly into a table is there any way i can protect that table so it can only be viewed by me but the form will still be able to feed in it. Something like a password system would be...

Using this technique, is there any way i can get the combobox to feed into a table? If i set the control source to the field i need can i specify which column from the combobox it inputs? I.e MyField = me.cboState.Column(2) Many thanks Tim

Thanks Col, i'll give it a go. Kind regards Tim