Upcoming dates

[Guest]

I have a field in a membership form called "expiry date". I want to create a
query or a report that shows all expired memberships and another one that
will show membership expiry in the next 2 months. Can this be done ?
Thanks

 

[Bob Barrows [MVP]]

I have a field in a membership form called "expiry date". I want to
create a query or a report that shows all expired memberships and
another one that will show membership expiry in the next 2 months.
Can this be done ?
Thanks

What is the definition of "expired membership"? Is it a record whose expiry
date is less than today? If so:

WHERE [expiry date] < date()

And for those that will expire in the next two months:

WHERE [expiry date] >=date() AND [expiry date] <
DATEADD("m",2,date())

Bob Barrows

 

[Guest]

Thanks. I have tried that but have just found a problem The field "expiry
date" is automatically updated from another field(date member joined + 1
yr)Thus not entered in table - is there a way around this.?
Thanks

I have a field in a membership form called "expiry date". I want to
create a query or a report that shows all expired memberships and
another one that will show membership expiry in the next 2 months.
Can this be done ?
Thanks

What is the definition of "expired membership"? Is it a record whose expiry
date is less than today? If so:

WHERE [expiry date] < date()

And for those that will expire in the next two months:

WHERE [expiry date] >=date() AND [expiry date] <
DATEADD("m",2,date())

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

 

[Bob Barrows [MVP]]

Show me the structure of your table, field names and datatypes - relevant
fields only.
I'm not clear whether [expiry date] is a field in the table.

Thanks. I have tried that but have just found a problem The field
"expiry date" is automatically updated from another field(date member
joined + 1 yr)Thus not entered in table - is there a way around this.?
Thanks

I have a field in a membership form called "expiry date". I want to
create a query or a report that shows all expired memberships and
another one that will show membership expiry in the next 2 months.
Can this be done ?
Thanks

What is the definition of "expired membership"? Is it a record whose
expiry date is less than today? If so:

WHERE [expiry date] < date()

And for those that will expire in the next two months:

WHERE [expiry date] >=date() AND [expiry date] <
DATEADD("m",2,date())

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

 

[Guest]

Relevent Fields in form
"Smart card member date joined" (--/--/----)
"Expiry Date" (in this is expression =DateSerial(Year([smart card member
date joined]),Month([Smart card member date joined])+12,Day([Smart card
member date joined]))
I also have conditional formatting to colour upcoming dates green and
expired dates red. All I need is to be able to print or see on screen this
information. Have tried setting up a report but the "expiry date" won't show
any data
Thanks for your help
--
SCP

Show me the structure of your table, field names and datatypes - relevant
fields only.
I'm not clear whether [expiry date] is a field in the table.

Thanks. I have tried that but have just found a problem The field
"expiry date" is automatically updated from another field(date member
joined + 1 yr)Thus not entered in table - is there a way around this.?
Thanks

SCP wrote:
I have a field in a membership form called "expiry date". I want to
create a query or a report that shows all expired memberships and
another one that will show membership expiry in the next 2 months.
Can this be done ?
Thanks

What is the definition of "expired membership"? Is it a record whose
expiry date is less than today? If so:

WHERE [expiry date] < date()

And for those that will expire in the next two months:

WHERE [expiry date] >=date() AND [expiry date] <
DATEADD("m",2,date())

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

 

[Bob Barrows [MVP]]

Relevent Fields in form
"Smart card member date joined" (--/--/----)
"Expiry Date" (in this is expression =DateSerial(Year([smart card
member date joined]),Month([Smart card member date
joined])+12,Day([Smart card member date joined]))
I also have conditional formatting to colour upcoming dates green and
expired dates red. All I need is to be able to print or see on screen
this information. Have tried setting up a report but the "expiry
date" won't show any data
Thanks for your help

As this no longer appears to be a "queries" question, I am bowing out of
this thread.

SCP, you wil probably get more focussed help for your problem by posting to
the appropriate newsgroup. I believe there's a "forms" group ... yes, there
is both "forms" and "formcoding".

 

[Guest]

Hello I have a similar problem. I have a table called authorizations.
Included is client name, authorization start date and authorization end dates
(among other things). I need to run a query to tell me who's authorization
is two weeks old and also every thirty days. After I create the query I
would like to set a macro to run it automatically. Problem is I am having
trouble with date formulas. Please help and spell it out like "access for
dummies" because I am so bad with these formulas.

Jessica