Adding blank records?

[ErinL]

Hi everyone!

I hope I explain this clearly enough. I have two queries created from a separate query. One (qryLoadDiagramLeft) pulls all the entries with "L" in the position field and the other (qryLoadDiagramRight) pulls all the entries with "R" in the position field.

I am using these queries in two different subreports (srptLoadDiagramLeft and srptLoadDiagramRight) on a main report (rptLoadDiagram).

The problem is that the two subreports don't line up the majority of the time because the rows are inconsistent on either side.

For example, row one may have 3 entries on the left side but only one on the right so the detail section of srptLoadDiagramLeft is taller than that of srptLoadDiagramRight and they don't line up. I would like to add two blank records on the right side to even them up.

Now:
Row Position StoreNumber Row Position StoreNumber
1 L 4658 2 R 7589
1 L 5874
1 L 4587

Desired:
Row Position StoreNumber Row Position StoreNumber
1 L 4658 2 R 7589
1 L 5874 2 R
1 L 4587 2 R

I am attaching a picture of the report as it looks now. Hopefully I have explained this clearly enough.

I am using Access 2007 although the database is in an mdb (2003) format.

Thank you for you ideas.