Hi, again
I have two fields with numbers and I want to have the sum of them in a third field
Please can you tell me how can I do it!

put both fields into your query then create an expression, something like this:

summedfield:[column1]+[column2]

Hope that helps

Where should I write this
summedfield:[column1]+[column2]
Thank you

Just put the formula in just like you would put in a new field into a query

I m sorry it isn't what I want.
To be more specific!
There is a query like:
Name Count1 Count2

John 20 10
Nick 30 25

but these numbers came as sum e.g. John 20 (18+5+7), 10 (5+5)
now I want a third field in the query with these three fields and one more with the total of every row 20+10=30
                       30+25=65

I think this would help!
Thank you

Put into the query as follows:

Sum(Count1+Count2) as Count3

HTH
Ashfaque

Thank you Ashfaque that's it!
Be well!!!

Vision G

Hi again,
When Column 1 is null and column 2 with a number it doesn' t show me the third column (sum}!
what should I do!!!

If you need it in query then it would be something like this: (Tested already)

SELECT Table1.Col1, Table1.Col2, IIf(IsNull(Table1.Col1),0,Table1.Col1) AS x1, IIf(IsNull(Table1.Col2),0,Table1.Col2) AS x2, ([x1]+[x2]) AS Col3
FROM Table1;

This will give you an idea.

Note that your data type field of the original table should be numeric

HTH
Ashfaque