how do i calculate values between two dates in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have details of investments made with maturity date starting from 2004. I
want to get a report for investments made in 2006/2007 and investments that
are maturing in 2006/07.
 
hi Ahmed,
I have details of investments made with maturity date starting from 2004. I
want to get a report for investments made in 2006/2007 and investments that
are maturing in 2006/07.
Click to expand...
Create a query and filter your maturity date. Use as criteria

BETWEEN DateSerial(2006, 1, 1) AND DateSerial(2007, 1, 1)


mfG
--> stefan <--
 
If your details include a date/time field for [DateOfInvestment], use a
query that selects those records in the date range. Then base your report
on your query.

If you have a [DateMaturing] field, or better still, a way to calculate it
from [DateOfInvestment] and [MaturesAfterNNDays].

If your details have none of these, I don't know how you'd select the
correct records.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top