Sorting Data from Access Db

[anticore]

=COUNTIFS(Table_crimestats.accdb[[#This Row],[station_id]], "station1",Table_crimestats.accdb[[#This Row],[crime_id]],"Assault",Table_crimestats.accdb[[#This Row],[date_occured]])

this works fine until the 3rd criteria, i need to pull the events of a certain month, the date is in ##/##/#### format.
can someone shed some light please.

[anticore]

--------------------------------------------------------------------------------

=COUNTIFS(Table_crimestats.accdb[[#This Row],[station_id]], "station1",Table_crimestats.accdb[[#This Row],[crime_id]],"Assault") this works fine, but i need to call up only the events that happened in lets say january

[T-J]

Use a new column formatted as "mmmm" and refering to the date column from the DB table, so it displays as July, August etc.
Then use the new column as one of the criteria in the COUNTIFS.

[anticore]

thanks worked great