Hi: Terry advised me to keep the

[Bass71]

Hi:

Terry advised me to keep the same issue on the same thread. However, I cannot figure out how to post a new question to the same thread. The last time I tried to post a question to thread #701-10125, I ended up responding to myself. So, I apologize for this and please direct me to the proper function

The question at hand is using the Nz function on a Crosstab query:

Thanks for the info. It worked beautifully in the Select query! Is it
also possible to use the Nz function in the 'Value' field of a Crosstab?

TRANSFORM Sum(Query1.[SumOfSumOfPrincipal Cash]) AS [The
Value]
SELECT Query1.[Account #], Query1.[Relationship Name],
Query1.Status
FROM Query1
GROUP BY Query1.[Account #], Query1.[Relationship Name],
Query1.Status
PIVOT Query1.Month;

Richard

 

[tlbroadbent]

Try this...

TRANSFORM Sum(Nz(Query1.[SumOfSumOfPrincipal Cash],0)) AS [TheValue]
Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin