Sum to fields of a query

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to sum two fields of the same query.
Any one can help me?

Regards,
John
 
Don't know if I've understood you but lets say your fields are called Field1
and Field2. Go into query design view and in the top row of the white grid,
in an empty column, type :


MySum: [Field1]+[Field2]

Instead of MySum you can type any name for the field which you want.

Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top