Access 2000, W2K
I am using a DSUM formula in one of my report fields to calculate a
dollar amount. When the user opens the report, they are prompted with
a box requesting Period End Date. The formula then adds a series of
numbers 27 days back from the date that the user enters. This all
works fine if the date does not cross over into last year, 2003. For
example, if I put a date of 1/28/2004 or higher, the formula works
great. If I put in 12/31/2003 or before, works like a charm. If I
put in a date that is before 1/28/2004 (which makes it calculate some
numbers from 2003 and 2004), it displays nothing on the report. Any
ideas? Here is the formula:
=Abs(DSum('[ARDate] >DateAdd("y", -27, [Period End Date])'))
Excuse the parenthesis, I may have missed one when typing the formula.
Thanks in advance!
Kevin