Exclude most recent month

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

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,
 
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)?
 
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
 
Back
Top