Null Values in Crosstab Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Microsoft Access 2003. I have a rather simple database. I have
created crosstab queries. I am trying to use the Nz function, but I must not
be entering it in properly. I need to know how, precisely, to add the Nz
function to a crosstab query created with the wizard. If there are any
sample databases online that I could look at, that'd be great as well!
 
If you would provide the SQL view of your query, we could provide exacting
assistance. Generically, you can set the Value to:
Val(Nz(Sum(YourField),0))
 
Back
Top