How to Set Active Period in a table

80 pts.
Tags:
Microsoft Access
Microsoft Access tables
Toggle buttons
I have defined financial periods in table. In this table i have defined 3 fields, 1-StartDate, 2EndDate, 3-ActiveDeactive. Field type of "ActiveDeactive" is set to Yes/No. One record should be ON and remaining all OFF I want to set any financial period as active period at any time

Software/Hardware used:
MS Access, P-4

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Abdul30dec
    I have defined financial periods in table. In this table i have defined 3 fields, 1-StartDate, 2-EndDate, 3-ActiveDeactive. Field type of "ActiveDeactive" is set to Yes/No. One record should be ON and remaining all OFF I want to set any financial period as active period at any time
    80 pointsBadges:
    report
  • Meandyou
    I think you need to clarify the question.
    5,220 pointsBadges:
    report
  • carlosdl
    Yes, you need to clarify your 'question', specially this part: "I want to set any financial period as active period at any time" Some example data could help.
    69,045 pointsBadges:
    report
  • Chippy088
    Sounds like this is a homework question. It is not clear how you want to use column 3. If 'Yes' is in the column, does it mean it is active or 'Inactive'. The column would be better marked with only one state 'Active', this is then determined in the content. I.E. Yes = Active, No = Inactive. Looking at Column 1 and 2 headings, I am not sure why you need the active/inactive column. Surely if the current date is between those in column 1 and 2, then it is 'active'. Maybe a bit more information as to how this table is to be used would help.
    4,625 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following