Problem with sub reports

[Macsterling]

You probably should cut and paste this into Word so the columns below align

I have a problem with a report. I have set up a generic process to compare any two files. After loading the files into an access database I run a series of generic queries and they identify any difference in any pair of records and displays both of the fields. Missing records are taken care separately.

To avoid running 30 different queries, I would like to put them in a report. I am using sub reports and cannot get them to work I have 2 problems:

1) When I open the detail section up enough to insert the sub report, it causes the query returns on the main report to be spread far far apart (spacing 6-10 lines apart) It’s almost as if I need additional detail lines for each sub report. How can I solve this?
2) Even though the second report will function on its own, when I insert it into the Main report, it cannot find its column (The field). I have opened up the properties of the first subreport (field 2) and set the sources equal to the MAS.FIELD2, and it still doesn’t work.
What am I doing wrong?

Database, query and report layout below (seven records on each file)


MAS file IVT file MASID and IVTID are keys

MASID Field1 Field2 Field2 IVTID Field1 Field2 Field3
1...........A1.......B1........C1..............1...........A1.......B1........C1............all fields match
2...........A2.......B2........C2..............2...........A2.......XX........A2.......... second field does not
3...........A3.......B3........C3..............3...........A3.......A3........A3............all fields match
4...........A4.......B4........C4..............4...........A4.......A4........YY............third field does not
5...........A5.......B5........C5..............5...........A5.......A5........A5........ ...all fields match
6...........A6.......B6........C6..............6...........ZZ.......A6........A6 ......... first field does not
7...........A7.......87........C7..............7...........QQ......A7........A7............first field does not

All of the queries are as follows: (If the indexes match, do the corresponding fields match?)

SELECT MAS.MASID, MAS.Field2, IVT.Field2 < ======= The name changes from
FROM IVT, MAS Field1 to Field2 to Field3 etc.
WHERE (((IVT.IVTID)=MAS.MASID) And ((IVT.Field2)<>MAS.Field2));

Query 1 (FIELD 1) MASID MAS.FIELD1 IVT.FIELD1
looks like this..........................6...................A6....................ZZ
...........................................7....................A7.....................QQ


Query 2 (FIELD 2) MASID MAS.FIELD2 IVT.FIELD2
...........................................2.....................B2.....................XX


Query 2 (FIELD 2) MASID MAS.FIELD3 IVT.FIELD3
............................................4...................C4............ .........


The report I want should somehow report on all the results.

Probably like this: (unless you can think of a better layout)


REPORT TITLE

MASID MAS FIELD IVT FIELD

FIELD 1..................6....................A6.......................ZZ
............................7....................A7.......................QQ

FIELD 2.................2......................B2...................... XX

FIELD 3.................4......................C4.......................YY


If I can leave off the report, a Field Line where the data is the same in both files, that would great.