how do i calculate values between two dates in access

[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.

 

[Stefan Hoffmann]

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.

Create a query and filter your maturity date. Use as criteria

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


mfG
--> stefan <--

 

[Jeff Boyce]

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/