Calculated Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top