How do I create equations for expiration dates in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use Access 2003 for my club roster, I need to create an equation that will
allow me to create a delinquent dues list from my expiration dates. I've
tried "expiration date"<01/01/2006 but it didn't work
 
ArthurRW said:
I use Access 2003 for my club roster, I need to create an equation that
will
allow me to create a delinquent dues list from my expiration dates. I've
tried "expiration date"<01/01/2006 but it didn't work
Click to expand...

Alas, "expiration date"<01/01/2006 does not appear to me to be an equation.

Assuming you have an expiration date in the table, open the Query Builder in
design view, and on the Criteria line underneath that ExpirationDate field,
enter

< #01/01/2006#

that should retrieve the records for all members whose Expiration Date is
prior to Jan. 1, 2006.

If you want to do something other than select those records, post back to
clarify.

Larry Linson
Microsoft Access MVP
 
I use Access 2003 for my club roster, I need to create an equation that will
allow me to create a delinquent dues list from my expiration dates. I've
tried "expiration date"<01/01/2006 but it didn't work
Click to expand...

This will compare the text string "expiration date" with the numeric
value 4.9850448654037e-4... probably not what you need!

What's the structure of your table? Do you have a stored expiration
date, or do you calculate it from the dues-paid date?

John W. Vinson[MVP]
 
John Vinson said:
This will compare the text string "expiration date" with the numeric
value 4.9850448654037e-4... probably not what you need!

What's the structure of your table? Do you have a stored expiration
date, or do you calculate it from the dues-paid date?

John W. Vinson[MVP]
I do have a stored expiration date, our club reregisters in Dec-Jan but there are always the late ones. What I'd really like to do is create an equation that will update month to month so I will always know who is in arrears.
Click to expand...
Art W
 
I do have a stored expiration date, our club reregisters in Dec-Jan but there are always the late ones. What I'd really like to do is create an equation that will update month to month so I will always know who is in arrears.
Click to expand...

A Query on the table with a criterion

< DateAdd("m", -1, Date())

on the expiration date field will return those members whose
expiration date is over a month in the past (from the moment you run
the query). You can use any other desired date expression.

John W. Vinson[MVP]
 
Back
Top