Crystal Reports Formula

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:
SELECT Bookmark.bkName
FROM Bookmark INNER JOIN File ON Bookmark.bkMarkID = File.bkMarkID
WHERE (((File.File)="File_1"));
FormulaQuery.pdf
Mark01Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
What database are you using?

You may be able to use a SQL Expression to get what you want.

Is the data in the query?

mlmcc
0
Mark01Author Commented:
I'm using Access 2010. Yes, the screenshot and PDF show the Access query that contains the data (Bookmark 1).
0
mlmccCommented:
Is that data not available in the report?

Is the Access database on the same database server as the report data?

Try this SQL Expression
(
SELECT Bookmark.bkName
 FROM Bookmark INNER JOIN File ON Bookmark.bkMarkID = File.bkMarkID
 WHERE (((File.File)="File_1"));
)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark01Author Commented:
The SQL Expression worked. No, that data is not available in the report. The Access database, Crystal Reports and Visual Cut are on the same workstation. No server is used.
0
Mark01Author Commented:
Thank you, mlmcc.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.