Heatmap style Form

[RobWulf]

I am trying to set up a form that gives me the following style of output for my ticket system and I can't seem to figure out what I am doing wrong.

                                    0-30  31- 60    61- 90  etc
Ticket Catagory 1
Ticket Catagory 2
Ticket Catagory 3
Ticket Catagory 4

I thought DCount might be what I need if I ran a query just looking for all the records and then used a sperate Dcount functon to look for each range

Me.Text5.Value = DCount("dateadded", "tbl_ticket", DateDiff("d", Now, dateadded < 90))

This kind of works, but instead of telling me what tickets are over 90 days old it tells me all of the tickets? ( I only have 3 loaded into my test database at the moment)

i have the following dates set up too

01/01/2012
03/15/2013
04/25/2013

Only one should be showing as over 90 days, what did I miss? or should I be using something other than Now() for the date? I want this report to be avalible every day since these tickets need to be moving at all times.

Thanks for any advice you can give me!

 

[jdraw]

There is a free video tutorial here that may be useful.