Find Records Between Two Dates and sum by multiple
Petya Pashova
10 years ago
Hi Instructor Rost, I enjoy your tutorials very much and help me build my first database. But I'm having issues with one of my reports. can you help me please? I created a quiry which runs for a specific date I enter. Then I created report on this query, I added totals for the values but I also need a subtotal of a set of the records. I use the Dsum function but since the report is within certain date range, I come up with an error on the Dsum. How to fix that error?
Reply from Alex Hedley:
Are you adding the date condition in your dsum Can you share the code you have used?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
