I asked this question yesterday, but everything I have tried still isn't
getting me what I want. I have 7 columns of dates that are dates that mark
stages in a project. Project ID# is my key. I need to know how many projects
were there that had no dates entered on Jan. 1, 2009. In other words, the
project had not advanced at all before 1/1/2009. There were no contracts, no
agreements, no plans drawn, no nothing for these 7 columns. I have tried is
null or 1/1/2009, I have tried Between 1/1/2000 and 1/1/2009 in all criteria
fields but I am just not getting the expected results. What else can I try, I
just can't get my head around it. I know we have 378 projects with about 170
that have never started and only 6 or 7 that have started since 1/1/2009 but
I just can't figure it out. Thanks, so much!!!!