I have this big table in Acces with lots of records. Every record have a
"date" field.

I wan't to count all records between two dates, and for that I use this SQL
string:
SELECT count(*) FROM v?penregister where ((v?penregister.dato_ut between
#07/01# and #09/30#));

This is working quite well, BUT if the date in one of the many records have
the year 1996, and the rest have 1997, the record with 1996 registered is
not counted!!!!!!!!!!!!

Is there a way to count records in a table no matter what year is
registered in the fields?

 SELECT count(*) FROM v?penregister where ((Month(v?penregister.dato_ut) between
 7 and 8 ) AND (DAY(v?penregister.dato_ut) between 1 AND 31));