I am trying to write a query in access to fill in blank cells with a match query,
This is something i would use in excell to do the same thing:-
but instead of a vlookup it would be a match query.
I only want to fill in the blank cells by matching a field to a field in another table and keep the original cells from the original data source.
Is this possible in Access?
Based on my research and tried in Access, I am afraid that the Access doesn’t support embedded SQL statement.
So I think the query is the wrong direction of this issue.
And in my view, maybe macro can do this.
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?