Function Similar to VLookup in Access? RRS feed

  • Question

  • I have a table of data where each row contains a unique number. In order to rearrange the data and merger various rows, I have had to remove this unique number and join the table with 2 crosstab queries.

    However, now I need to bring back at least one unique number. For example:

    Unique Number Reference Payment Type Expected Payment Actual Payment 

    12743234                3546575 DD 10 5

    12743235 3546575 Cash 20 15

    I have merged the two lines together based on the reference, now I need to bring back either 12743234 or 12743235. If I were to use a vlookup formula in excel, it would return the first one. Is this possible to do in sql? I tried Dlookup but it hasn't worked.

    Friday, February 15, 2013 5:23 PM

All replies