Sum of a column in Access VBA
Im trying to make an Excel file from an Access query. I need to calculate the amount for each column in the resulting table and add them to the last row as SUM. I transferd a table from queries to Excel sheet, but I can not add the amount. Is it possible to use the VBA inside Access to find the height of a column and add the sum of the column to the next cell?
Thanks!
excel vba access
asked Nov 23 '18 at 7:20
WittgensteinWittgenstein
405
add a comment |
Im trying to make an Excel file from an Access query. I need to calculate the amount for each column in the resulting table and add them to the last row as SUM. I transferd a table from queries to Excel sheet, but I can not add the amount. Is it possible to use the VBA inside Access to find the height of a column and add the sum of the column to the next cell?
Thanks!
excel vba access
asked Nov 23 '18 at 7:20
WittgensteinWittgenstein
405
Why do you want to work in this way? You can create a query in Access, and in Excel, choose to import data from that MS-Access database (I believe it's possible to choose the query from which you want to import), and once imported in Excel, you can add the sum at the end using standard Excel featurs.
– Dominique
Nov 23 '18 at 9:12
add a comment |
Im trying to make an Excel file from an Access query. I need to calculate the amount for each column in the resulting table and add them to the last row as SUM. I transferd a table from queries to Excel sheet, but I can not add the amount. Is it possible to use the VBA inside Access to find the height of a column and add the sum of the column to the next cell?
Thanks!
excel vba access
asked Nov 23 '18 at 7:20
WittgensteinWittgenstein
405
Im trying to make an Excel file from an Access query. I need to calculate the amount for each column in the resulting table and add them to the last row as SUM. I transferd a table from queries to Excel sheet, but I can not add the amount. Is it possible to use the VBA inside Access to find the height of a column and add the sum of the column to the next cell?
Thanks!
excel vba access
excel vba access
asked Nov 23 '18 at 7:20
WittgensteinWittgenstein
405
asked Nov 23 '18 at 7:20
WittgensteinWittgenstein
405
asked Nov 23 '18 at 7:20
WittgensteinWittgenstein
405
asked Nov 23 '18 at 7:20
WittgensteinWittgenstein
405
asked Nov 23 '18 at 7:20
WittgensteinWittgenstein
405
405
Why do you want to work in this way? You can create a query in Access, and in Excel, choose to import data from that MS-Access database (I believe it's possible to choose the query from which you want to import), and once imported in Excel, you can add the sum at the end using standard Excel featurs.
– Dominique
Nov 23 '18 at 9:12
add a comment |
Why do you want to work in this way? You can create a query in Access, and in Excel, choose to import data from that MS-Access database (I believe it's possible to choose the query from which you want to import), and once imported in Excel, you can add the sum at the end using standard Excel featurs.
– Dominique
Nov 23 '18 at 9:12
Why do you want to work in this way? You can create a query in Access, and in Excel, choose to import data from that MS-Access database (I believe it's possible to choose the query from which you want to import), and once imported in Excel, you can add the sum at the end using standard Excel featurs.
– Dominique
Nov 23 '18 at 9:12
Why do you want to work in this way? You can create a query in Access, and in Excel, choose to import data from that MS-Access database (I believe it's possible to choose the query from which you want to import), and once imported in Excel, you can add the sum at the end using standard Excel featurs.
– Dominique
Nov 23 '18 at 9:12
add a comment |
1 Answer
1
active
oldest
votes
If you do not want to do any job with functions in excel you could simply do it in the sql query in access and choose to export the query result. Here is an example:
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2]
FROM Table1
union all
SELECT 'sum', sum(Table1.[Field1]), sum(Table1.[Field2])
FROM Table1;
answered Nov 23 '18 at 8:16
W_O_L_FW_O_L_F
39928
Thanks a lot! I
– Wittgenstein
Nov 23 '18 at 9:11
If the solution is what you intended, please mark the solution as accepted. Thanks!
– W_O_L_F
Nov 23 '18 at 10:57
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%2f53442217%2fsum-of-a-column-in-access-vba%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
If you do not want to do any job with functions in excel you could simply do it in the sql query in access and choose to export the query result. Here is an example:
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2]
FROM Table1
union all
SELECT 'sum', sum(Table1.[Field1]), sum(Table1.[Field2])
FROM Table1;
answered Nov 23 '18 at 8:16
W_O_L_FW_O_L_F
39928
Thanks a lot! I
– Wittgenstein
Nov 23 '18 at 9:11
If the solution is what you intended, please mark the solution as accepted. Thanks!
– W_O_L_F
Nov 23 '18 at 10:57
add a comment |
If you do not want to do any job with functions in excel you could simply do it in the sql query in access and choose to export the query result. Here is an example:
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2]
FROM Table1
union all
SELECT 'sum', sum(Table1.[Field1]), sum(Table1.[Field2])
FROM Table1;
answered Nov 23 '18 at 8:16
W_O_L_FW_O_L_F
39928
Thanks a lot! I
– Wittgenstein
Nov 23 '18 at 9:11
If the solution is what you intended, please mark the solution as accepted. Thanks!
– W_O_L_F
Nov 23 '18 at 10:57
add a comment |
If you do not want to do any job with functions in excel you could simply do it in the sql query in access and choose to export the query result. Here is an example:
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2]
FROM Table1
union all
SELECT 'sum', sum(Table1.[Field1]), sum(Table1.[Field2])
FROM Table1;
answered Nov 23 '18 at 8:16
W_O_L_FW_O_L_F
39928
If you do not want to do any job with functions in excel you could simply do it in the sql query in access and choose to export the query result. Here is an example:
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2]
FROM Table1
union all
SELECT 'sum', sum(Table1.[Field1]), sum(Table1.[Field2])
FROM Table1;
answered Nov 23 '18 at 8:16
W_O_L_FW_O_L_F
39928
edited Nov 23 '18 at 8:21
answered Nov 23 '18 at 8:16
W_O_L_FW_O_L_F
39928
answered Nov 23 '18 at 8:16
W_O_L_FW_O_L_F
39928
answered Nov 23 '18 at 8:16
W_O_L_FW_O_L_F
39928
39928
Thanks a lot! I
– Wittgenstein
Nov 23 '18 at 9:11
If the solution is what you intended, please mark the solution as accepted. Thanks!
– W_O_L_F
Nov 23 '18 at 10:57
add a comment |
Thanks a lot! I
– Wittgenstein
Nov 23 '18 at 9:11
If the solution is what you intended, please mark the solution as accepted. Thanks!
– W_O_L_F
Nov 23 '18 at 10:57
Thanks a lot! I
– Wittgenstein
Nov 23 '18 at 9:11
Thanks a lot! I
– Wittgenstein
Nov 23 '18 at 9:11
If the solution is what you intended, please mark the solution as accepted. Thanks!
– W_O_L_F
Nov 23 '18 at 10:57
If the solution is what you intended, please mark the solution as accepted. Thanks!
– W_O_L_F
Nov 23 '18 at 10:57
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.
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%2f53442217%2fsum-of-a-column-in-access-vba%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
Why do you want to work in this way? You can create a query in Access, and in Excel, choose to import data from that MS-Access database (I believe it's possible to choose the query from which you want to import), and once imported in Excel, you can add the sum at the end using standard Excel featurs.
– Dominique
Nov 23 '18 at 9:12