ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Subtotal with tax (https://www.excelbanter.com/excel-discussion-misc-queries/205854-subtotal-tax.html)

Renee

Subtotal with tax
 
I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?

Mike

Subtotal with tax
 
Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Renee

Subtotal with tax
 
You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Mike

Subtotal with tax
 
It will take vba code to do this. Do you know how to write code ? If it was
me instead of exporting it from access I would have excel pull the data I
needed.



"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Mike

Subtotal with tax
 
I would set it up so that all you do is press a button.

"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Renee

Subtotal with tax
 
I can pull the data from Access that I need? Don't think I have heard of
that. I have entered some vba code but not created my own, I am just starting
to learn how to write it.

"Mike" wrote:

It will take vba code to do this. Do you know how to write code ? If it was
me instead of exporting it from access I would have excel pull the data I
needed.



"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Mike

Subtotal with tax
 
With a few changes you could use this. If you would send my the workbook I
could get you started. Its up to you.

Private Sub getDataFromAccess()
'Needs reference the Axtive X Library 2.0 or higher
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sSQL As String, strConn
Dim rowNumber As Long

'C:\PathToYourMdb\Ilsa.mdb (Change)
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:\PathToYourMdb\Ilsa.mdb;Persist Security Info=False"

'sSQL = "Replace with your query"
sSQL = "SELECT Field1, Field2 From TableName"

Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset

cnn.Open strConn
rs.Open sSQL, cnn, adOpenStatic, adLockOptimistic
rowNumber = 2 'Starting Row Number for data
Do While (Not rs.EOF)
Range("A" & rowNumber) = rs.Fields("Field1").Value
Range("B" & rowNumber) = rs.Fields("Field2").Value
rowNumber = rowNumber + 1
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
cnn.Close
Set cnn = Nothing
End Sub

"Renee" wrote:

I can pull the data from Access that I need? Don't think I have heard of
that. I have entered some vba code but not created my own, I am just starting
to learn how to write it.

"Mike" wrote:

It will take vba code to do this. Do you know how to write code ? If it was
me instead of exporting it from access I would have excel pull the data I
needed.



"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Renee

Subtotal with tax
 
Wow, that sounds like it would take some time for me to figure out how to do.
I will have to look into it for later. For now can you help me with the code
for when the query is exported to excel?

"Mike" wrote:

I would set it up so that all you do is press a button.

"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Mike

Subtotal with tax
 
I can but trust me it would be easier for me if you send me a copy of the
workbook.


"Renee" wrote:

Wow, that sounds like it would take some time for me to figure out how to do.
I will have to look into it for later. For now can you help me with the code
for when the query is exported to excel?

"Mike" wrote:

I would set it up so that all you do is press a button.

"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Renee

Subtotal with tax
 
But then how do I do it for the rest of the time? As I would need to do this
once a week.

"Mike" wrote:

I can but trust me it would be easier for me if you send me a copy of the
workbook.


"Renee" wrote:

Wow, that sounds like it would take some time for me to figure out how to do.
I will have to look into it for later. For now can you help me with the code
for when the query is exported to excel?

"Mike" wrote:

I would set it up so that all you do is press a button.

"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Mike

Subtotal with tax
 
I could set it up to pull in the data from the workbook that was exported
from access
Press the button and it will run.

"Renee" wrote:

But then how do I do it for the rest of the time? As I would need to do this
once a week.

"Mike" wrote:

I can but trust me it would be easier for me if you send me a copy of the
workbook.


"Renee" wrote:

Wow, that sounds like it would take some time for me to figure out how to do.
I will have to look into it for later. For now can you help me with the code
for when the query is exported to excel?

"Mike" wrote:

I would set it up so that all you do is press a button.

"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Renee

Subtotal with tax
 
How do I go about sending you a copy of the workbook?

"Mike" wrote:

I could set it up to pull in the data from the workbook that was exported
from access
Press the button and it will run.

"Renee" wrote:

But then how do I do it for the rest of the time? As I would need to do this
once a week.

"Mike" wrote:

I can but trust me it would be easier for me if you send me a copy of the
workbook.


"Renee" wrote:

Wow, that sounds like it would take some time for me to figure out how to do.
I will have to look into it for later. For now can you help me with the code
for when the query is exported to excel?

"Mike" wrote:

I would set it up so that all you do is press a button.

"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Mike

Subtotal with tax
 
Send to

"Renee" wrote:

How do I go about sending you a copy of the workbook?

"Mike" wrote:

I could set it up to pull in the data from the workbook that was exported
from access
Press the button and it will run.

"Renee" wrote:

But then how do I do it for the rest of the time? As I would need to do this
once a week.

"Mike" wrote:

I can but trust me it would be easier for me if you send me a copy of the
workbook.


"Renee" wrote:

Wow, that sounds like it would take some time for me to figure out how to do.
I will have to look into it for later. For now can you help me with the code
for when the query is exported to excel?

"Mike" wrote:

I would set it up so that all you do is press a button.

"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?


Renee

Subtotal with tax
 
There, email is sent from

"Mike" wrote:

Send to


"Renee" wrote:

How do I go about sending you a copy of the workbook?

"Mike" wrote:

I could set it up to pull in the data from the workbook that was exported
from access
Press the button and it will run.

"Renee" wrote:

But then how do I do it for the rest of the time? As I would need to do this
once a week.

"Mike" wrote:

I can but trust me it would be easier for me if you send me a copy of the
workbook.


"Renee" wrote:

Wow, that sounds like it would take some time for me to figure out how to do.
I will have to look into it for later. For now can you help me with the code
for when the query is exported to excel?

"Mike" wrote:

I would set it up so that all you do is press a button.

"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?



All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com