Report generation

[Mukhmoor]

I have a table name property with fields propertyid, houseno, address, housestatus(empty or rent) and another table lease with fields leaseid, propertyid, startdate, enddate, monthlyrent. I need a yearly report showing the number of months in which house remained empty. Is it possible to generate this report with above fields? If yes then how? Thnx

 

[Trevor G]

Welcome to the Forum,

First look to create a query based on both tables just to get the overall picture, name it something like qryPropertyMain.

Next what you need to do is look to see how many times the properties are shown and then you would need to look at the StartDate and EndDate Fields it is here you will need to look at criteria to see when a property hasn't been rented.

If you could upload a sample of your database someone will probably take a look for you. Please state which version of MS Access you are using, that will help the Forum to look at guiding you.

 

[Mukhmoor]

Access version is 2007.

 

[Mukhmoor]

Thnx Trevor. I created a query based on both tables but i m not sure what criteria to use to get the number of months in a specific year with property status 'empty'.

 

[Access N0vice]

I think you would just set the property value =to null and it should give you all records with the value as empty

 

[boblarson]

criteria would be

Is Null