Access crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
You set the Value to something like:
Val(Nz(Sum([YourField]),0))
If this doesn't help then come back with your current SQL View.
 

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

How to multiply percentages in a CROSSTAB-action (instead of e.g. SUM) 3
Using Crosstab column headings for conditional formatting in report 0
Dynamic column in report using crosstab query 20
crosstab query 3
Fill Blanks with Zero on CrossTab 4
Summary row in crosstab query? 3
Crosstab queries - populating blanks with zeros 3
Crosstab queries, <> and null values 3

Back
Top