Subform Issues

  • Thread starter MissJane11 via AccessMonster.com
  • Start date
M

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
 
K

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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top