Query last day of previous month

[programmingrookie]

I have a table which includes a "reportdate" column and a "balance" column.
Each month may have several reports, but always one on the final day of the
month. I want to create a query to use as a base of an Access report that
provides only the balances from the previous month's final day balance
report, and disregards any other balance reports for that month. For
example, on August 1 I would like to pull the July 31 balances.

Any ideas?

 

[John Spencer]

To get records on the last day of the previous month use criteria of

DateSerial(Year(Date()),Month(Date()),0)

Field: ReportDate
Criteria: DateSerial(Year(Date()),Month(Date()),0)



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