Prev: Input form
Next: How do I use dlookup in a form to find a specific field
From: John W. Vinson on 30 Mar 2010 19:12
On Tue, 30 Mar 2010 14:58:01 -0700, daisy <daisy(a)discussions.microsoft.com>
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]
From: daisy on 31 Mar 2010 11:09
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 <daisy(a)discussions.microsoft.com>
> 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]
> .
>
From: John W. Vinson on 1 Apr 2010 14:48
On Wed, 31 Mar 2010 08:09:01 -0700, daisy <daisy(a)discussions.microsoft.com>
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]
From: John W. Vinson on 2 Apr 2010 22:29
On Fri, 2 Apr 2010 17:53:01 -0700, daisy <daisy(a)discussions.microsoft.com>
wrote:

>Hi John, thank you for responding. I would like to create a filter for new
>records coming in based on AddedDt

Put a criterion on AddedDt of

< DateSerial(Year(Date()), Month(Date()), 1)

and it will pull all records with an AddedDt prior to the first day of the
current month.

>and then I would like to somehow link all data associated with the
>CustomerID & CustomerName to pull thru as well?

Create a Query. Add this table (whatever it is) and the customer table, joined
by CustomerID. Pull the Event, EffQtr, InvoiceAmt and so on from this table,
and the CustomerName and any other desired fields from the Customer table.

Get to know queries. They are *absolutely basic* to any constructive use of
Access, and they're the very basis of relational database design!

--

John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2
Prev: Input form
Next: How do I use dlookup in a form to find a specific field