How to calculate the sum of a column in an MS Access table for a given date (a single day, month or year)
- by cMinor
I have a table in Access in a custom format saved as dd/MM/yyyy hh:mm:ss tt , Also A form in VB.NET 2010, I get a specific day, month and year with no problem but the problem comes when I want to query the sum of a column named value depending on a specific month or day or year....
The table is like:
+-----+-----------+-------------------------+…