Update target where source <> ""

[peak@accessforums]

Access 2013. I have two tables with the same structure, ML and MLTemp. I want to update ML from MLTemp whith the fields in MLTemp which are not empty, that is I want to avoid writing an empty value from MLTemp into a field in ML that has a value already.

Is there a way to do that in VBA/SQL without looping through each field in MLTemp and check if it's not empty?

Best regards


George

[orange]

George,

Welcome to the forum.
Just about anything is possible with some amount of programming. Databases are usually designed and built to support some type of business. And it often helps readers understand questions/opportunities when the business need is described.

Having tables with exactly the same structure is not too common.

You say you want to update fields in one table from another without using vba or sql.

What you have described is often done using a query. But behind a query is sql. When you look at the query wizard you see a user interface, but behind that is SQL.

Can you show readers your table designs? Screen capture of the table design window would help.

[peak@accessforums]

Hello Orange,

I'm sorry but you totally misunderstood. Of course I want to use SQL and VBA. That's what I wrote. I don't want looping.

George,

Welcome to the forum.
Just about anything is possible with some amount of programming. Databases are usually designed and built to support some type of business. And it often helps readers understand questions/opportunities when the business need is described.

Having tables with exactly the same structure is not too common.

You say you want to update fields in one table from another without using vba or sql.

What you have described is often done using a query. But behind a query is sql. When you look at the query wizard you see a user interface, but behind that is SQL.

Can you show readers your table designs? Screen capture of the table design window would help.

[orange]

Sorry for misunderstanding. Glad you clarified your point.
What fields uniquely identify records in each table?
What have you tried so far? What results occurred?
Do you have an aversion to looping or is this just academic?
It would still be useful to readers to see your table designs, field names and data types.

[NTC]

make a query of MLTemp; select a field and put in its criteria: Not Is Null

this query then will result in only records with data