Selecting a Single Record for Report

[FSBOStaff]

I don't use CR very often, but this should be simple. I need to print a report with a single record selected from one table in Access97 based on the values written to another table by a Visual Basic application. The record selection formula I've written is:
{Payments.Issue} = {CurrentIssue.Issue_ID} and
{Payments.Pmnt_No} = {CurrentIssue.Payment_ID} and
{Payments.Acct_No} = {CurrentIssue.Acct_ID}
The report returns blank. What am I missing here?

 

[dgillz]

You do not need a record selection formula to fo this.

Just link from the temp table (the one with one record) to the table with many records. Place at least one field from the temp table on the report canvas (you can supress it if you don't want to see it) along with the rest of the fields as desired. Be sure to use a left outer join from the temp table to the 2nd table.

If this still doesn't work, your field values are not equal. Check for trailing or leading spaces.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz