M
mike
I export data every week from Access 2000 to Excel. The data is a query
listing about 100 service calls showing downtime. I then total the downtime,
insert another worksheet in the workbook and do various calculations down one
column with the answers in the next column to to give me a summary sheet and
a detail sheet (the original data). I can do the calculations on form in
Access 2000 but if I export the form the filed names go across the top of
the sheet with the results below, not down one column. Can I export data to a
template and pick the cells the data gets inserted in or is there a better way
listing about 100 service calls showing downtime. I then total the downtime,
insert another worksheet in the workbook and do various calculations down one
column with the answers in the next column to to give me a summary sheet and
a detail sheet (the original data). I can do the calculations on form in
Access 2000 but if I export the form the filed names go across the top of
the sheet with the results below, not down one column. Can I export data to a
template and pick the cells the data gets inserted in or is there a better way