MS Access - Display days as number of years in combobox
The row source of my combobox is set to "365;730;1095;1461;1826".
I need to store the values in my table as number of days but I want to display them as years (1;2;3;4;5) from my combobox.
Is it possible? How?
I've tried =Year([Duration]) but it doesn't work.
ms-access
asked Nov 22 at 13:19
Barbara
1,20022039
add a comment |
The row source of my combobox is set to "365;730;1095;1461;1826".
I need to store the values in my table as number of days but I want to display them as years (1;2;3;4;5) from my combobox.
Is it possible? How?
I've tried =Year([Duration]) but it doesn't work.
ms-access
asked Nov 22 at 13:19
Barbara
1,20022039
1
=[Duration]/365?
– Lee Mac
Nov 22 at 13:29
add a comment |
The row source of my combobox is set to "365;730;1095;1461;1826".
I need to store the values in my table as number of days but I want to display them as years (1;2;3;4;5) from my combobox.
Is it possible? How?
I've tried =Year([Duration]) but it doesn't work.
ms-access
asked Nov 22 at 13:19
Barbara
1,20022039
The row source of my combobox is set to "365;730;1095;1461;1826".
I need to store the values in my table as number of days but I want to display them as years (1;2;3;4;5) from my combobox.
Is it possible? How?
I've tried =Year([Duration]) but it doesn't work.
ms-access
ms-access
asked Nov 22 at 13:19
Barbara
1,20022039
asked Nov 22 at 13:19
Barbara
1,20022039
asked Nov 22 at 13:19
Barbara
1,20022039
asked Nov 22 at 13:19
Barbara
1,20022039
asked Nov 22 at 13:19
Barbara
1,20022039
1,20022039
1
=[Duration]/365?
– Lee Mac
Nov 22 at 13:29
add a comment |
1
=[Duration]/365?
– Lee Mac
Nov 22 at 13:29
1
1
=[Duration]/365?– Lee Mac
Nov 22 at 13:29
=[Duration]/365?– Lee Mac
Nov 22 at 13:29
add a comment |
1 Answer
1
active
oldest
votes
Use two columns:
"1;365;2;730;3;1095;4;1461;5:1826"
and hide the second column.
That said, the count will only always be true for four years due to the leap years.
answered Nov 22 at 14:05
Gustav
29.3k51734
No need to be super accurate so leap years won't be a problem. Thanks.
– Barbara
Nov 22 at 22:36
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431918%2fms-access-display-days-as-number-of-years-in-combobox%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Use two columns:
"1;365;2;730;3;1095;4;1461;5:1826"
and hide the second column.
That said, the count will only always be true for four years due to the leap years.
answered Nov 22 at 14:05
Gustav
29.3k51734
No need to be super accurate so leap years won't be a problem. Thanks.
– Barbara
Nov 22 at 22:36
add a comment |
Use two columns:
"1;365;2;730;3;1095;4;1461;5:1826"
and hide the second column.
That said, the count will only always be true for four years due to the leap years.
answered Nov 22 at 14:05
Gustav
29.3k51734
No need to be super accurate so leap years won't be a problem. Thanks.
– Barbara
Nov 22 at 22:36
add a comment |
Use two columns:
"1;365;2;730;3;1095;4;1461;5:1826"
and hide the second column.
That said, the count will only always be true for four years due to the leap years.
answered Nov 22 at 14:05
Gustav
29.3k51734
Use two columns:
"1;365;2;730;3;1095;4;1461;5:1826"
and hide the second column.
That said, the count will only always be true for four years due to the leap years.
answered Nov 22 at 14:05
Gustav
29.3k51734
answered Nov 22 at 14:05
Gustav
29.3k51734
answered Nov 22 at 14:05
Gustav
29.3k51734
answered Nov 22 at 14:05
Gustav
29.3k51734
29.3k51734
No need to be super accurate so leap years won't be a problem. Thanks.
– Barbara
Nov 22 at 22:36
add a comment |
No need to be super accurate so leap years won't be a problem. Thanks.
– Barbara
Nov 22 at 22:36
No need to be super accurate so leap years won't be a problem. Thanks.
– Barbara
Nov 22 at 22:36
No need to be super accurate so leap years won't be a problem. Thanks.
– Barbara
Nov 22 at 22:36
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431918%2fms-access-display-days-as-number-of-years-in-combobox%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
=[Duration]/365?– Lee Mac
Nov 22 at 13:29