Result set from comparing two fields

[bkno]

Hopefully someone can help me. I am developing a report from an Access database. I need to compare all the Loan Numbers in one table to the all of the loan numbers in another table (in the same Access database) and print the values that match. Both fields are string types.

Thanks in advance...

 

[lbass]

If you use an equal join to link the loan numbers from each table, only the matching loan numbers will be displayed in your results.

-LB

 

[bkno]

I have a report request that needs to show exactly what is seen on the front end (Empower). I’m having difficulty creating a query that will give me the result to satisfy the requester’s needs. The tables Fees and Disbursement sit on a Oracle Database and the .Primary key is the Number field. I’ve tried joining the tables on the Number Field which results in duplicates line items. As you can see some of the Disbursement line items are represented in the Fees table by a Hud number and some aren’t. I need to see all of the line items in Disbursement table that are represented by a Hud Number (in the Fees Table) and all of the line items in the disbursement table that aren’t represented by a Hud number. With a result set like the one I have shown below.

Fees Table
Num idx hud fee type amt feepaidto disptyp chknum
6567 4 803 Appraisal 600 Riemburse 0
6567 3 1106 N Fee 200 North 1 1106

Disbursement Table
Num idx transtyp disptyp disbpay disbamt disbdate
6567 2 Rienburse 600 6/12/05
6567 25 chk Apprais 200 6/14/05
6567 7 wire N Fed 1663 6/02/05
6567 8 wire GE 9925 6/07/05

Example of Result Set
Num Hud Fee AcctPaid Amt Date DistType Check#
6567 800 600 6/12/05 600 6/12/05 Rienburse
6567 1106 200 6/14/05 200 6/14/05 Appris 1106
6567 1663 6/02/05 1663 6/02/05
6567 1595 6/07/05 9925 6/07/05

 

[dgillz]

bkno,

Start a new thread.

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

http://www.gainfocus.biz