Calculations On Access Query Results

K

Kelv

Joined
May 22, 2006
Messages
3
Reaction score
0
Hi, I have a set of query results that I want to analyse in Excel but when I paste the results into Excel I cannot calculate on the data.

E.G. Sum(D1:E3) returns 0 but Sum(D1+E3) etc works.

I've narrowed this to the nz() function I'm using in the query to return the number 0 (zero) if the contents is null. If I remove this function from the query then the results calculate fine in Excel.

Can this problem be solve?

Much appreciated,

Kelv
 
Solved me own problem for those who are interested :-)

Cint(nz([FieldName],0))

The results then can be pasted into Excel and calculations run correctly.

Hope someone else finds this helpful.

Kelv
 

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

Similar Threads

Replace result of 0 with empty string (null) 2
Nz function 0
Access #Error & Excel Pivot 0
Calculated result in query problem 1
Time in calculated field for shifts going past midnight 0
Running sum on access query 2
crosstab query without calculations 4
Crosstab query with multiple fields 2

Back
Top