Can a formula return the equivalent value of a query result (Bookmark 1), such as the Access query shown below? The screenshot shown below shows the Access query. In other words, if you drag the File_1-Bookmark formula onto a report, it should display "Bookmark 1." Please help me write a formula that will display "Bookmark 1."
Here is the Access query:
FROM Bookmark INNER JOIN File ON Bookmark.bkMarkID = File.bkMarkID