Posted: Sat Aug 27, 2011 9:20 pm Post subject: Access Coding Need Help
First of all; I know that access is met for database only, but I wanna learn something so I start this project for fun. Second, I don't know if this is rite for me to post it here since it's related to coding.
I don't really need help in creating this database, but what I need help is the calculation part. According to excel; the code for "Total Collected 9/1/11" is:
Code:
=sumif(D2:200,"9/1/11",C2:200)
So to those who don't understand what this code means; it means
Between C2 to C200; Calculate only if field D2 to D200 equal 9/1/11. _________________
nevermind I found my answer after playing around with the calculation.
It's =DSum("[Table that you want to calculate]","TableName","[optional: Table that you want to compare or filter with]=date format which is #X-X-XXXX#") _________________
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum