Sum to fields of a query

  • Thread starter Thread starter John
  • Start date Start date
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
 
Back
Top