How Do I Calculate A Profit For Each Month In Ms Access?

I'm quite new to access and I am currently in the process of making a database for my company. I have a 'Jobs' table with these fields in: Job No. Year Initiated Month Initiated

Solution 1:

You want to find all rows matching a specific year / month, and add together all the profit entries for that month to get a total?

If so, try this :

selectsum(profit) from Jobs whereyear=2013andmonth=02

Or, if you want to retrieve this information for all months in one go, try this :

selectyear, month, sum(profit) from Jobs groupbyyear, month