Your calculation is doing exactly what you told it to do. Of course that's not what you want it to do. You'll need a way to pull all the records for the current client for the current year into a group and add up the charges of that group of records. There are several ways you can do this. Depending on the method chosen, you can then use either a different form of the sum function or a summary field to compute the YTD total.
You appear to have other issues, however, judging from your screen shot. Your Time Billing table contains client contact info. That suggests you may have multiple records for the same client in your billing table--each with separate copies of this contact information. Instead, you should define a Clients table with ClientID (serial number), name fields, phone, address etc and link it to a ClientID field you would also define in Time Billing. That enables you to have one record for each client and a portal to Time Billing that shows you all the billing records for that client. This portal can even be filtered to show a specific date range such as all the billing records for a specified year.
Thanks, Phil. OK, let me see if I cam narrow this down a bit. Some of your assumptions are incorrect, but I think my description was poor. Let me try to restate this.
It's a simple db. Every time I have a job, I set up a total in the db. Each record is separate, and has, in practicality, no connection to the other. Each Record has a "Total" box, which is a calculation of 3 other boxes (hrs/rate/adjustments). What I want to do is sum ALL the "Total" boxes into one box. Thanks.
That "box" is called a field ;-)
In that case, use a summary field with the "total of" option. Select your Total field as the field for it to summarize.