I'm trying to match up a few different lists to one main list. If a match is not found, it will leave it blank. Below is what I would like the report to show:

ESJN-------- S_ESJN------ M_ESJN----- P_ESJN
461 ---------- S461 --------- M461 --------- P461
462 ---------- S462 --------- M462 --------- P462
463 -----------S463 -------------------------- P463
464 --------------------------------------------P464
465 ---------- S465 --------- M465

Any ideas how I would go about doing it. I tried using subreports, but it lists the matching records one after the other instead of leaving a blank space.

Thank you in advance for your help.

This is something that should be done in a set of queries.

You need a query to create a matching column for each of S_ESJN etc.

Select fieldname, right(fieldname,3) as match from tablename

SO if those 3 queries are called QS, QP and QM you then have a fourth query which includes the ESJN table and the 3 queries.

You link from ESJN to QS on the field to the Match field in QS. You then right click the join line and change the Join type so that it includes all records from ESJN and any matching records from QS.

Do the same from ESJN to QM and ESJN to QP.

You can then inldue all the original fields from the ESJN table and the queries in the output.