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))
 

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

Crosstab queries, <> and null values 3
Crosstab with multiple fields 2
Crosstab query problems 11
Parameter Value in Crosstab Query 4
Make-table query with around 2 ml records taking too long 0
Query a crosstab query 2
Help on crosstab query 2
Parameter Queries in Crosstab Query 2

Back
Top