By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

DateAdd Glitch?

P: n/a
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!

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
No Spam previously wrote:
=Abs(DSum('[ARDate] >DateAdd("y", -27, [Period End Date])'))

Don't think so:

What are you trying to sum?

Dsum ("[field to sum]","tablename","Criteria")

Peter Russell
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.