Subtraction using 3 fields

[Guest]

One more question and I should be done with my first foray into Access. All
of your help is greatly appreciated.

From my table [Resolved by Hospice Date Worked], I need to subtract
[Pharmacy Credits] plus [Credit Amount] from [Sales Amount].

Using the Expression Builder, I have tried various versions of the following
Expression:
Total Non-Credits: Sum([Sales Amount])-(Sum([Pharmacy Credit])+Sum([Credit
Amount]))

When I try to run the query, I get an error message stating that I have an
extra ) in the expression. When I each ) in turn, I get an error message
stating I am missing ),] or |.

Thank you in advance for your help and patience with someone just starting
out.

 

[Guest]

I must be learning something, I was able to resolve this.