Douglas,
The values in ReadmitMonth are date values - all are the first day of a
month (i.e. 2/1/10, 3/1/10).
Chuck

"Douglas J. Steele" wrote:

What's stored in ReadmitMonth: a number (1 through 12), text (Jan through
Dec), or something containing month and day (2010/01 through 2010/12)?


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"Chuck W" wrote in message
...
Hello,
I have a query called qryReadmits based on a table called tblReadmits that
has fields such as ReadmitMonth, AccountNumber, Readmit (1 or 0),
Population
(always 1). Data is populated into tblReadmits on a periodic basis.
Sometimes the data is fairly current (2 months behind) and other times it
is
up to four months behind. I want to create a query where I group by month
the readmission rate which is Readmit divided by Population. But I want
to
always exclude the most receent month that is available. I want to
automate
this since I will be reporting it each month. Can someone give me ideas
on
how to always exclude the most recent month regardless of how old the data
is?

Thanks,


.