Re: Return a Yes or No value on a date
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Thu, 23 Oct 2008 17:26:09 +0800
Set the Control Source of the check box on your report to:
=([paid up to] > Date())
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Rod in Oz" <RodinOz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5F6A2471-7AE1-4616-B248-254269A53050@xxxxxxxxxxxxxxxx
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.
.
- Follow-Ups:
- Re: Return a Yes or No value on a date
- From: Rod in Oz
- Re: Return a Yes or No value on a date
- References:
- Return a Yes or No value on a date
- From: Rod in Oz
- Return a Yes or No value on a date
- Prev by Date: Return a Yes or No value on a date
- Next by Date: RE: Calculated column in your report
- Previous by thread: Return a Yes or No value on a date
- Next by thread: Re: Return a Yes or No value on a date
- Index(es):
Relevant Pages
|
