Recent content by JLB1

  1. J

    Solved Problems with crosstab

    I think arnelgp's subquery idea will work, but it may run pretty slow. I think I might just dump the query results into a table and run some code to remove the uneeded zeros and link my Excel template to the table. =) Thank you for all the help.
  2. J

    Solved Problems with crosstab

    Thank you, I'll give that a try.
  3. J

    Solved Problems with crosstab

    This is actually just sample data, the real data is counting a text field, not a number. But the problem is everything I try either changes every null value to a zero or none of them. I can't seem to get to where future months are null, but null values in the current/previous months (where there...
  4. J

    Solved Problems with crosstab

    Thank you for your reply. Unfortunately, the methods in that article (and everything else I could find) replaces all null values with zeros, even for future months with no data. I've attached two screenshots, "Zeros" shows the results using a formula IIf(IsNull(Count([WIN])),0,Count([WIN])))...
  5. J

    Solved Problems with crosstab

    Hi. I have created a monthly crosstab query that has column headings defined for the current year, and what I need is to show zeros where there is no data for the previous months, but null/blank values for future months and I'm not sure this is possible. Any suggestions?
  6. J

    Hi All.

    I'm new to this forum. I'm an experienced Access programmer. I'm self taught, so I only know what I've had to figure out. =)
Top Bottom