Re: Return a Yes or No value on a date

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
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:B7E75380-4E6B-4898-942E-9F88558FDE50@xxxxxxxxxxxxxxxx
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.

"Allen Browne" wrote:

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

"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.

.

Relevant Pages

  • Re: Return a Yes or No value on a date
    ... I've tried that and if I set the Control Source as suggested ... body of the report, ... Allen Browne - Microsoft MVP. ... I created a membership report to return all members in ...
    (microsoft.public.access.reports)
  • Re: Return a Yes or No value on a date
    ... Allen Browne - Microsoft MVP. ... I've tried that and if I set the Control Source as suggested ... I created a membership report to return all members ...
    (microsoft.public.access.reports)
  • Re: For Marshall Barton
    ... Control Source: IncType ... Second Subreport: ... As they appear in the Detail Section of the Main Report: ... function in the report footer will work ok, ...
    (microsoft.public.access.reports)
  • Re: For Marshall Barton
    ... However, when I ran the report, it kept ... After fixing the IIf problem, ... Control Source: ABegBal ... "The LEVEL clause includes a reserved word or argument that is misspelled or ...
    (microsoft.public.access.reports)