How and where to insert Nz Function in a Crosstab Query for graphi

G

Guayo

I'm constructing a line tendence graphic; I'm refering to records from a
CrossTab Query (CTQ) with Months of a year in Columns and Cost ($) of the
desire months in Files; but, the column of the month where a didn't have
records, doesn't shows amount of cost because doesn't exist; but I need the
line tendence of my graphic shows "0" cost in these month; by the way, my CTQ
takes records from Cost Tables and Incident Tables, and Month Columns of the
year deplayed, are the result of the "Between Initial And Final" criteria
insert in my CTQ; I know that I need to use the Nz Function to transform Null
fields to "0" but, I don't know how and where to insert it, exactly.
Can somebody help me?
Thanks says Guayo from Osorno, Chile.
 
D

Duane Hookom

Enter all possible months in the Column Headings property. You can use Nz()
in the value expression. Since you haven't provided the SQL view of your
query, I can't be of much more help.
 

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

Use of Nz Function in Access 2000 Crosstab Query 2
Use of Nz Function in a Crosstab Query 1
Use of Nz Function in expresion 1
Use of Nz Function in Access 2000 2
Use of Nz Function in Queries 7
Select vs crosstab query - different result 1
How to link Crosstab Query to other query problem... 7
Insert a crosstab to temp table for report 6

Top