How to write expression in table?urgent help please

[#1]

Hi,

I have a fields ID, Type, Days and I need to write expression which shows the count of ID where

days Less than 100 Days, days Less than 2 year, days greater than 100 Days

can anyone suggest me how can I calculate this.

Thanks.

[#2]

Thanks.

[ThornOfCrowns]

If this answer is correct, please mark it so.

Also, why is everything such a hurry / high priority / urgent? I'd speak to your boss regarding unrealistic deadlines.