<div>
Select CellID, DateDiff(&quot;m&quot;,DateField, Date()) As MonthsRemainning From MyTable Order By CellID<br />
<br />
Change table name and fields names an make a query out of above SQL.<br />
<br />
Mike
</div>


Select CellID, DateDiff("m",DateField, Date()) As MonthsRemainning From MyTable Order By CellID

Change table name and fields names an make a query out of above SQL.

Mike

<div>
change to: &nbsp;DateDiff(&quot;m&quot;,Date,DateFiel<wbr />d) 
</div>


change to:  DateDiff("m",Date,DateField)

<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I have an Access database with a table that has all of the Cellular phones on my company's account. &nbsp;One of the fields in each record is the date on which the service contract ends for that phone. &nbsp;What can I do to get Access to calculate how many months is left on the contract?<br />
<br />
Thanks.
</div>
</div>


Hello all,

I have an Access database with a table that has all of the Cellular phones on my company's account.  One of the fields in each record is the date on which the service contract ends for that phone.  What can I do to get Access to calculate how many months is left on the contract?

Thanks.

Remaining Months

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.