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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top