Counts before and after today

[chrisd49]

Hi All
I need to be able to do a count before and after the current date.
My table has fields named month and year and I need to find the count before and after the current month. Any help would be much appreciated.
ChrisD

 

[pdx_man]

SELECT COUNT(*)
FROM MyTable
WHERE MyMonth <> MONTH(Date())

 

[chrisd49]

Thanks PDX
This worked a treat and allowed me to develop it further to give exactly the result i wanted.
ChrisD