On Wed, 31 Mar 2010 08:09:01 -0700, daisy
wrote:

Hi John, Maybe this will help. I'm not sure how to build this form with
criteria before the month I've just added?

Here's my table structure
EffQtr
EffYear
OrigDt
Region
CustomerID
CustomerName
DealStDt
DealEndDt
Event
InvoiceAmt
ListAmt
LocalAmt
AnnualFees
AddedDt

Looks like you have a lot of date or date-related fields: EffQtr, EffYr,
OrigDt, DealStDt, DealEndDt, AddedDt. Which of these do you want to use as a
criterion - AddedDt? And what do you mean by "build the form with criteria
before the month"???? Example please!
--

John W. Vinson [MVP]