Monthly payment problem

[zaky]

Hi !

I was wondering if someone could help me on tenant maintenance DB.My problem is i need something to control the rent payment for ex: if the tenant pays the rent to take off his/her name from the due rent list until the next month. I know it is something to do with query but I need an idea or if I could get sample DB it would be greatly appreciated.

Thnx

 

[spacepro]

You need to post some more info.

There are loads of scenarios, please be a bit more specific.

It could be easy as putting Null in the criteria of the Paid field, but maybe not depending upon your design.

Andy

 

[zaky]

thnx Spacepro for your time I realy appreciate your kindness. Let me explain the best I can. Here is the situation I have two tables "tenant and payment" for instance a tenant pays the rent and I input the amount he/she paid what I want is a query to show me all the tenants who did not pay the rent this month that is all. I hope I explained myself let me know if you need more information. Thank you again Spacepro.

 

[spacepro]

Can you post your table design?

If you have a date field and a paid field in your tables then you could add the fields you want in your query and in the criteria section of the design grid put the following:

Criteria                                                           Field

Between [Enter Start Date] And [Enter End Date]  Date Field

Null                                                                Paid Field

Hope this helps

The query will then ask you for two dates and return all records within the date range you entered where the paid field is Null(empty) ie Not paid.

Andy