I have 2 tables, Table A and Table B.  They each have account numbers that I need to link together, however, they are stored differently in each table.

 

As an example, say that Table A has account number stored as 123456789 in one field (call the field Acct).

 

However, in Table B, the same account number is broken out into two separate fields.  So in Table B, you have a field that has 1234 (call it Field 1), and then an entirely separate field that has 56789 (call it Field 2).

 

So I need to link the Acct field from Table A to a combination of Field 1 and Field 2 from Table B.  Does that make sense?

 

I can do it via a subreport (I create a formula merging Field 1 and Field 2 and then link that formula to Acct in the primary report), but I didn't know if there was another way.  I'm not a big fan of subreports and would like to avoid it if possible.

 

Thoughts?  Thanks, Mike