Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting To Excel

Status
Not open for further replies.
marydn

marydn

Programmer
Mar 26, 2001
152
US
Hi- I want to export an Access table to Excel. However, I want the sum of some fields to be included in the spreadsheet. These sums are not present in the table.Is there an easy way to code this? Any help is greatly appreciated.

M.
 
Sort by date Sort by votes
create a query based on the table and include whatever sums you need in the query. Then instead of exporting the table, export the query.

Hope i haven't been too vague.

Nick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
484
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
361
Viswa.R
Viswa.R
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
758
Knicks
Knicks
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel Password Protect Fail
Replies
5
Views
1K
combo
combo
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
358
Zyborg
Zyborg

Part and Inventory Search

Sponsor

Back
Top