Date Diff

Hello,

In my property management database, I'm trying to calculate how many months
are left (from today) on a lease (based on [LeaseExpiryDate]). How would I
write this expression in a query?

Thanks,

Debbie

Debbie,

The simple answer is...
DateDiff("m",Date(),[LeaseExpiryDate])

However, it really depends on exactly what you mean by "how many
months". Do you *whole* months, or completed calendar months, or what?
The above expression will return 2 months if LeaseExpiryDate is 1st
August, based on August being 2 months distant from June - is that what
you would expect?

--
Steve Schapel, Microsoft Access MVP

D. M. wrote:
Hello,

In my property management database, I'm trying to calculate how many months
are left (from today) on a lease (based on [LeaseExpiryDate]). How would I
write this expression in a query?

Thanks,

Debbie

Steve,

That solves the problem!!! Thanks!

"Steve Schapel" wrote:

Debbie,

The simple answer is...
DateDiff("m",Date(),[LeaseExpiryDate])

However, it really depends on exactly what you mean by "how many
months". Do you *whole* months, or completed calendar months, or what?
The above expression will return 2 months if LeaseExpiryDate is 1st
August, based on August being 2 months distant from June - is that what
you would expect?

--
Steve Schapel, Microsoft Access MVP

D. M. wrote:
Hello,

In my property management database, I'm trying to calculate how many months
are left (from today) on a lease (based on [LeaseExpiryDate]). How would I
write this expression in a query?

Thanks,

Debbie

Hello,
I am fairly new to using Access and I'm in the process of trying to design
our property management database. Did you create your own database in Access
or did you purchase your property management software? Also, remarkably I
was actually looking for an answer to the same question you asked yesterday.
So, thank you.

TRS

"D. M." wrote:

Hello,

In my property management database, I'm trying to calculate how many months
are left (from today) on a lease (based on [LeaseExpiryDate]). How would I
write this expression in a query?

Thanks,

Debbie

TRS,

I created my own database. It's not the best, but it's better than working
with spreadsheets (as was done before me). I have completed the database
(including reports, etc.) with the exception of the accounting portion.
We're still doing manual calculations for 111 properties every
month/quarter/year.

I'm having a hard time trying to figure out how to do percentage rent
calculations in the database. We're thinking of hiring someone to create a
separate module for this.

Good luck with your database. It's been a long 6 months for me!!!

Debbie

"TRS" wrote:

Hello,
I am fairly new to using Access and I'm in the process of trying to design
our property management database. Did you create your own database in Access
or did you purchase your property management software? Also, remarkably I
was actually looking for an answer to the same question you asked yesterday.
So, thank you.

TRS

"D. M." wrote:

Hello,

In my property management database, I'm trying to calculate how many months
are left (from today) on a lease (based on [LeaseExpiryDate]). How would I
write this expression in a query?

Thanks,

Debbie

Dear Debbie--

Thank you for getting back to me. I'm sure it will be a long 6 months or
even year for me as well. At least now, I know it's worthwhile doing. I'm
tired of working with the spreadsheets as well, not very efficient. I don't
really want the accounting portion in Access. I would use Quickbooks
software. QB We currently use MAS Accounting software because we have many
facets of our business. I would like our property management division to be
better organized. I do know someone who works in Access quite a bit. If he
has any suggestions regarding the percentage rent calculations, I'll let you
know. I have not seen him in a bit, but when I do I'll mention it to him.

Tracy

"D. M." wrote:

TRS,

I created my own database. It's not the best, but it's better than working
with spreadsheets (as was done before me). I have completed the database
(including reports, etc.) with the exception of the accounting portion.
We're still doing manual calculations for 111 properties every
month/quarter/year.

I'm having a hard time trying to figure out how to do percentage rent
calculations in the database. We're thinking of hiring someone to create a
separate module for this.

Good luck with your database. It's been a long 6 months for me!!!

Debbie

"TRS" wrote:

Hello,
I am fairly new to using Access and I'm in the process of trying to design
our property management database. Did you create your own database in Access
or did you purchase your property management software? Also, remarkably I
was actually looking for an answer to the same question you asked yesterday.
So, thank you.

TRS

"D. M." wrote:

Hello,

In my property management database, I'm trying to calculate how many months
are left (from today) on a lease (based on [LeaseExpiryDate]). How would I
write this expression in a query?

Thanks,

Debbie

Tracy and Debbie,

Just want to say how cool it is that you two are doing this. Most
people find it challenging to get over the initial learning humps with
Access, but you both seem to have understood that it is worth the effort
Congratulations to you both on what you have achieved so far!

I have recently put together a collection of synopses of examples of
Access applications that some of the MVPs have worked on. It's to
illustrate some of Access's flexibility and strength. You may enjoy to
look at it here...
http://accesstips.datamanagementsolutions.biz/apps.htm

On a more practical note, Debbie, please feel free to post to the
newsgroup your specific questions about your percentage calculations
etc, there are always experienced people willing to help.

--
Steve Schapel, Microsoft Access MVP

TRS wrote:
Dear Debbie--

Thank you for getting back to me. I'm sure it will be a long 6 months or
even year for me as well. At least now, I know it's worthwhile doing. I'm
tired of working with the spreadsheets as well, not very efficient. I don't
really want the accounting portion in Access. I would use Quickbooks
software. QB We currently use MAS Accounting software because we have many
facets of our business. I would like our property management division to be
better organized. I do know someone who works in Access quite a bit. If he
has any suggestions regarding the percentage rent calculations, I'll let you
know. I have not seen him in a bit, but when I do I'll mention it to him.