BAQ with SubQuery (finding Currency Rate)

Check out this post, it shows you how to set up a sub-query.

Also, it’s really hard for anyone to help you when we don’t know what it is that you did. I’m sure it’s something simple, but if you don’t explain at least some of the things you tried, we have no way of knowing what you are missing.