Query with Conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can anyone help me with this i have a table of renters who have pay for their
rental property each month on the 1st. The details are entered on the 1st. I
want to run a report on the 3 rd of each month that tells me who has not paid
for the property on the first.

thanks
 
Do you have a table of renters and another table of payments?

SELECT Renters.*
FROM Renters
WHERE Renters.RenterID NOT IN
(SELECT Payments.RenterID
FROM Payments
WHERE Payments.PaidDate > DateSerial(Year(Date()),Month(Date()),1))

Replace the tablenames with you tablenames and the field names with your field
names. IF this is too slow or doesn't work then post back with some details on
your tables and fields.
 
Back
Top