Posted by paulmac106 on 07/03/06 12:17

Hi,

I have 2 tables: tblStatements and tblLines (one to many) Any
tblStatements record can have many associated records in tblLines.
The search criteria is against tblLines (ie tblLines.fldDateofService
>= '6/1/06' and tblLinesfldDateofService < '7/1/06'.) I join by tblStatements.fldStatementPK and
tblLInes.fldStatmentID (one to many)

I need to return a recordset that will look like (after i pass the
date range)

Total Statements Total Lines
136 1,123
24 869

the problem i get when i join the two tables is that i get this:

Total Statements Total Lines
1,123 1,123
869 869

any help or direction would be greatly appreciated.

[Back to original message]