本文介绍了DSum功能的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 您好, 我正在尝试编写一个函数,该函数会将Credit Hours查询中的Hours列与用户定义的日期范围相加。这是我到目前为止的功能。 = DSum([小时],学分时间,日期> = [输入开始日期(MM) / DD / YY)]< = [输入结束日期(MM / DD / YY)]") 好​​像它应该可以工作,但我一直在#错误。我的功能出了什么问题?我一直在试着把头发拉出来。 谢谢, 查理Hello, I''m trying to write a function that will sum the Hours column in the Credit Hours query for a user defined date range. This is the function that I have so far. =DSum("[Hours]","Credit Hours","Date>=[Enter Start Date (MM/DD/YY)] And <=[Enter End Date (MM/DD/YY)]") It seems like it should work, but I keep getting a #Error. What is wrong with my function? I have been pulling my hair out trying to figure this out. Thanks, Charlie推荐答案 以下哪一项都有效? Either of the following will work? 展开 | 选择 | Wrap | 行号 这篇关于DSum功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
10-25 09:31