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
--
Thank you in advance!!!!


"John W. Vinson" wrote:

On Tue, 30 Mar 2010 14:58:01 -0700, daisy
wrote:

thank you how would the form pull in data associated with it that is older
than the current data?

By using appropriate criteria. Since I know nothing about your "current data",
nor the structure of your table, nor exactly what you're looking for it's a
bit hard to give a specific answer! For data with a datefield prior to today's
date, you can use

Date()

on the criteria line.
--

John W. Vinson [MVP]
.