I am using the below on Dlookup to no avaii:
JckRank: dllookup([Rank], "JckRanks", "AthroughB.[Jockey] = "Ranks.[Jck]")
I am trying to get the ranks of a jockey from a table called JckRanks as below:
In another Table named AthroughB, there is a column named Jockey.
In this query, I am trying to get the name of the jockey from table AthroughB and get the rank of that jockey from table JckRanks. For Example if the jockey name in the column named Jockey from table AthroughB is Nakatani, I want the query to get the rank of 4. There are 1800 named jockeys.