Search results
-
H
How to search for all values in one table in multiple fields in another table and update or create a new table in ms access?
Didn't do the trick. I still get only the BCG code if (SearchFor1 = BANCONTACT) and SearchFor2=Gunther) en no BCE but BCG code instead if (SearchFor1 = BANCONTACT) and SearchFor2=Evelien). Thank you for your answer and time. EDIT: I found what the reason was. I changed the OR in AND in your... -
H
How to search for all values in one table in multiple fields in another table and update or create a new table in ms access?
I found a VBA solution for the problem. Please take a look at the msaccess db in attachment of this message. I created a module ( WalkTruhCodes) and that does the job pretty well for looking after the searchfor1 values and add the code to the table. But now i have the following question. How... -
H
How to search for all values in one table in multiple fields in another table and update or create a new table in ms access?
I know i have to find a way to identify a unique string and maybe with a second identifier field in the code table that will lookup with a AND statement that will be executed if there is a value in the second identifier field. The database that i have uploaded is my personal edited version to... -
H
How to search for all values in one table in multiple fields in another table and update or create a new table in ms access?
Both tables are temporary and will be cleaned after it's import to production table. It is a bank transaction summery that i will download weekly, First i have to cleanup the import because the first 10 lines are a bunch of information from the bank. I have attached the ms access database with... -
H
How to search for all values in one table in multiple fields in another table and update or create a new table in ms access?
Indeed, PAY should be PAP, I edited and removed the typo. I will give this a try and come back with the results. The idea is to perform the query after the import in the temporary table before it goes to the production table. That way it it doesn't matter that it is a little slow at that moment... -
H
How to search for all values in one table in multiple fields in another table and update or create a new table in ms access?
I have a problem and can't find a solution or don't know how to describe it. I'm trying to create an ms access database for our accounting. I import a bank transfers summary from our bank as a csv file and import it temporary to Table2 (TmpBankImport). Now I would like to automate and add a code...