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

DSum #Errors When Date Parameter Used

P: n/a
I have a select query with a few DSum expressions, but when I add a
between and ending date parameter to Date Sold, the results show
#Error in two (discount and net sales) of the four gross total
columns. This is a sales activity query that has GT Units Sold, GT
Gross Sales, GT Discount, and GT Net Sales columns. Without using the
date parameter, all grand totals are computed correctly. Not that it
should be an issue, I am using NZ as part of the DSum expressions.

Does anyone have any ideas as to why this can occur? Thanks.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.