Return a Yes or No value on a date

[Rod in Oz]

I am pretty much a novice with Access.

I created a membership report to return all members (easy so farfor me) in
the database. I want to add an indicator (Yes or No) at the end of each
member's line in the report to indicate whether or not they are financial.
I have a field with a short date value that lists the "paid up to" date.
I'm not sure how to return a 'yes' or tick if the date is beyond today's
date and a 'no' if it is equal to today's date or a past date.

I would welcome any help.

 

[Allen Browne]

Set the Control Source of the check box on your report to:
=([paid up to] > Date())

 

[Rod in Oz]

Hi Allen,

I've tried that and if I set the Control Source as suggested
=([Paid_To]>Date()), the report asks for a Date.

If I create the Text Box in the header with simply =Date() in the Control
Source I get today's date returned. If I then move the same Text Box to the
body of the report, it asks for a date.

If I set the Control Source to =[Paid_To] I get the paid to date returned OK.

I guess I'm doing something wrong.

Set the Control Source of the check box on your report to:
=([paid up to] > Date())

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am pretty much a novice with Access.

I created a membership report to return all members (easy so farfor me) in
the database. I want to add an indicator (Yes or No) at the end of each
member's line in the report to indicate whether or not they are financial.
I have a field with a short date value that lists the "paid up to" date.
I'm not sure how to return a 'yes' or tick if the date is beyond today's
date and a 'no' if it is equal to today's date or a past date.

I would welcome any help.

 

[Allen Browne]

Make sure the name of the text box is not Date, or any field name like
Paid_To.

Open a code window, and choose References on the Tools menu. Make sure none
are marked with the word MISSING. More info on solving problems with library
references:
http://allenbrowne.com/ser-38.html

Make sure Name AutoCorrect is turned off, in case there ever was a field,
caption, or alias with the name Date. Then compact the database. More info
on the problems Name AutoCorrect gives:
http://allenbrowne.com/bug-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi Allen,

I've tried that and if I set the Control Source as suggested
=([Paid_To]>Date()), the report asks for a Date.

If I create the Text Box in the header with simply =Date() in the Control
Source I get today's date returned. If I then move the same Text Box to
the
body of the report, it asks for a date.

If I set the Control Source to =[Paid_To] I get the paid to date returned
OK.

I guess I'm doing something wrong.

Set the Control Source of the check box on your report to:
=([paid up to] > Date())

I am pretty much a novice with Access.

I created a membership report to return all members (easy so farfor me)
in
the database. I want to add an indicator (Yes or No) at the end of
each
member's line in the report to indicate whether or not they are
financial.
I have a field with a short date value that lists the "paid up to"
date.
I'm not sure how to return a 'yes' or tick if the date is beyond
today's
date and a 'no' if it is equal to today's date or a past date.

 

[Rod in Oz]

Hi Allen,

That worked. Thanks for your assistance.

Make sure the name of the text box is not Date, or any field name like
Paid_To.

Open a code window, and choose References on the Tools menu. Make sure none
are marked with the word MISSING. More info on solving problems with library
references:
http://allenbrowne.com/ser-38.html

Make sure Name AutoCorrect is turned off, in case there ever was a field,
caption, or alias with the name Date. Then compact the database. More info
on the problems Name AutoCorrect gives:
http://allenbrowne.com/bug-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi Allen,

I've tried that and if I set the Control Source as suggested
=([Paid_To]>Date()), the report asks for a Date.

If I create the Text Box in the header with simply =Date() in the Control
Source I get today's date returned. If I then move the same Text Box to
the
body of the report, it asks for a date.

If I set the Control Source to =[Paid_To] I get the paid to date returned
OK.

I guess I'm doing something wrong.

Set the Control Source of the check box on your report to:
=([paid up to] > Date())

I am pretty much a novice with Access.

I created a membership report to return all members (easy so farfor me)
in
the database. I want to add an indicator (Yes or No) at the end of
each
member's line in the report to indicate whether or not they are
financial.
I have a field with a short date value that lists the "paid up to"
date.
I'm not sure how to return a 'yes' or tick if the date is beyond
today's
date and a 'no' if it is equal to today's date or a past date.