How To Count Dates on Report?

[netchie]

Funny, I was going to send you a personal message coz I know you can help me lol. How to add you as my friend on here coz you ROCK!!

Ok, I'll check this out and I'll get back to you of course ASAP!

[netchie]

All are correct but Future StartDate is still counting as 1 .

Please see attached.

[rpeare]

then change the part of the formula that deals with the start date/current date

you said start date < current date wasn't right and now you say start date > current date isn't right either so I'm not sure exactly what you're after anymore.

[netchie]

Hi rpeare,

I just typed it wrong. it works fine now

Thanks so so much and hope you won't stop helping me for future Access issues of mine

Thanks again,netchie