Calculated Field

P

Paul Mendlesohn

I have a query that has three fields:

Contact ID, Sum of SubscriptionAmount, Sum of JoiningFee
Where SuscriptionAmount and JoiningFee are fields from a table that has
duplicated ContactIDs each with some subscriptions and joining fees. This
query works well.

I need to have the sum of the SubscriptionAmount and JoiningFee either in
the same query or another one but I can't work out how to do it.

I have tried using this expression in the original query, in a field
Total: ([Sum of SubscriptionAmount] + [Sum of JoiningFee])
But this doesn't work.

Thanks Paul
 
T

Tom Ellison

Dear Paul:

Please post the SQL code of your query. Likely someone will be able to see
just what you're doing and give you some help.

Tom Ellison
 
Top