Subform Issues

[MissJane11 via AccessMonster.com]

I have a main form which holds the general information about a finance
contract (i.e Contract Number, Financier, Paid in full date etc)

I then have a subform which holds the income received for each contract.

I want to have a report that shows the contracts that have not received any
income for a period of time.

The Main form is not the problem, what is is the subform. If I don't have
any income received yet obviously all fields in the subform remain blank, and
this is what I am trying to pick up.
I was wondering if there was anyway to create a blank record in the subform
on execution of the contract number in the main form

Any help is appreciated

 

[KARL DEWEY]

Try this --
SELECT [Contract Number], [Financier], [Paid in full date]
FROM [ContractTable] LEFT JOIN [PaymentTable] ON [ContractTable].[Contract
Number] = [PaymentTable].[Contract Number]
WHERE [PaymentTable].[Contract Number] Is Null;