I need to set up an expired records expression

[Guest]

I work my club membership database. Dues expire throughout the year and I
need to create an expression to alert me using [Expiration Date] and
[TodaysDate]. I tried [Expiration Date]<[TodaysDate] but all I get are 0's on
expired and current members

 

[Duane Hookom]

Is [TodaysDate] a field value? If you want to use today's date in a query
(or other places), you can use the function Date().

 

[Guest]

[TodaysDate] and [Expiration Date] are both field values, I used Date0 to get
my current [TodaysDate] and type in the expiration dates for each member of
my club, but I want to create an expression that will show, in a report,
which records have expired on any date I happen to call up that report.
Example: today is 01/01/2006, 20 of my members' dues expired 12/31/2005, my
delinquency report shows the names of the 20 members whose dues expired
yesterday.

Is [TodaysDate] a field value? If you want to use today's date in a query
(or other places), you can use the function Date().

--
Duane Hookom
MS Access MVP
--

I work my club membership database. Dues expire throughout the year and I
need to create an expression to alert me using [Expiration Date] and
[TodaysDate]. I tried [Expiration Date]<[TodaysDate] but all I get are 0's
on
expired and current members

 

[Duane Hookom]

I would just add two text boxes on a form txtFrom and txtTo. Then create a
query that has a where clause like:

WHERE [Expiration Date] Between Forms!frmMyForm!txtFrom and
Forms!frmMyForm!txtTo

--
Duane Hookom
MS Access MVP
--

[TodaysDate] and [Expiration Date] are both field values, I used Date0 to
get
my current [TodaysDate] and type in the expiration dates for each member
of
my club, but I want to create an expression that will show, in a report,
which records have expired on any date I happen to call up that report.
Example: today is 01/01/2006, 20 of my members' dues expired 12/31/2005,
my
delinquency report shows the names of the 20 members whose dues expired
yesterday.

Is [TodaysDate] a field value? If you want to use today's date in a query
(or other places), you can use the function Date().

--
Duane Hookom
MS Access MVP
--

I work my club membership database. Dues expire throughout the year and
I
need to create an expression to alert me using [Expiration Date] and
[TodaysDate]. I tried [Expiration Date]<[TodaysDate] but all I get are
0's
on
expired and current members