The only think I can think of is to carefully check the date of death and make
sure the correct year has been entered. Make sure the date is 2007 and not
1907 or 2107 or ...

Also, make sure the month is December.

If you are storing Date of Death in a text field, Access may be attempting to
convert the string to dates for you. If so, it could be misunderstanding the
date string and converting 03/12/2007 to March 12, 2007 when you expect it to
see that as December 3, 2007.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

caseysmydog wrote:
John, this working very well except for the 12 month query.
For instance, we had 4 people die in Dec., '07.
Yet it pulls only 2.
The other two are lower day dates in Dec. than the two pulled.
For all the other months, the formula has pulled successfully and the day
dates do not affect, can be higher or lower.
Can you share your thoughts?
Many thanks