Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Access Query (if is blank then lookup)

Answered Access Query (if is blank then lookup)

  • Monday, June 18, 2012 10:42 PM
     
     
    Sign In to Vote
    0

    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:-

    =IF(E5="",VLOOKUP(A5,Sheet3!$A$3:$B$18,2,FALSE),E5)

    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?

     

All Replies

  • Wednesday, June 20, 2012 1:17 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    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.

    Jaynet Zhang

    TechNet Community Support