Query help / search specific records

[MissJane11 via AccessMonster.com]

Hi all

I have a fairly simple database that has a main form which holds the
following information: Contract Number, Customer Name, Financier, Broker,
Date Settled, Date Paid in full.

Then I have a subform which has the following information:
Contract number (hidden) period of, income received, GST exclusive, date paid.


So one contract can receive income for many months in a row until it is paid
in full.

I am trying to run a query that picks up a contract that has not received
income for a particular month. For example they may have received something
for 1/2/09, 1/4/09 and 1/5/09 but not for 1/3/09. I am trying to pick up that
nothing has been received in march so further investigation can be done. As
nothing has been keyed in for march, it obviously wont pick up a 'is null'
field.

How do i do this?

Thanks heaps

 

[Allen Browne]

Use a subquery in the Filter property of the main form.

See:
Subquery basics: Identifying what is NOT there
at:
http://allenbrowne.com/subquery-01.html#NotThere