<div>
You want dateAdd()<br />
<br />
DateAdd(&quot;h&quot;,-[HoursField],<wbr />[DateField<wbr />])<br />
<br />
and also if you want the time between two date fields, you would use DateDiff().<br />
<br />
Jim.
</div>


<div>
Hi Jim,<br />
Thank your for your response. <br />
I tried this but instead of getting the desired result in Datetime format, I get the result as 1040815 when I tried <br />
<br />
DateDiff(&quot;h&quot;,-[HoursField]<wbr />,[DateFiel<wbr />d]) &nbsp;where the value &nbsp;of Hoursfield is 12 and value of DateField is 9/12/2018 7:00 Am <br />
<br />
The datefield is datetime field and Hoursfield is a computed Integer field. <br />
I'm expecting the result in the form 9/11/2018 7:00 Pm for the above values.<br />
Please advise, what I may be doing wrong.<br />
Thanks
</div>


Sivasan

<div>
Jim,<br />
Awesome. That worked. Thanks a million.....
</div>


<div>
Awesome answer...Thanks a million
</div>


<div>
<div class="content wysiwyg-content">
Hi There,<br />
I have two field in access one datetime &nbsp;field say StartDate like 9/10/2018 7 am and another field in &nbsp;Hour &nbsp;say NoHrs example 12 hours<br />
Minus this Datetime with the field &nbsp;hours in access query so I get something like 9/10/2018 7am - 12 hours &nbsp;the result to be 9/9/2018 7 PM.<br />
I would appreciate if anybody can let me know how I can do this.<br />
Thanks
</div>
</div>


Hi There,
I have two field in access one datetime  field say StartDate like 9/10/2018 7 am and another field in  Hour  say NoHrs example 12 hours
Minus this Datetime with the field  hours in access query so I get something like 9/10/2018 7am - 12 hours  the result to be 9/9/2018 7 PM.
I would appreciate if anybody can let me know how I can do this.
Thanks

Minus this Datetime with the field  hours in access query

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.