Data transfer from Access to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello there;

I have been working on a report that will be emailed out automatically using
the SendObject macro which generates a new Excel spreadsheet each time its
run. This report is a weekly report that displays an agents call time, handle
time, number of calls answered, and displays the daily stats, with a total
stats just below the respective columns.

The problems that I am having is that for: 1 - I can't get the totals to
come out correctly, 2 - I can't get the totals to come out in the respective
columns, and 3 - I need to come up with a way to get the hours worked to show
correctly using one field instead of two fields.

On the Report form, I have text boxes set up to gather the needed
information and to be able to print out in Excel spreadsheet, however, all
the totals are displaying along ROW 1 of the excel spreadsheet, and I need
these totals to show up underneath the weekly listings, similar to a
summation of fields. I read somewhere that Excel spreadsheets can't use the
footer section of the report form, and therefore, can you help me to figure
out how to get the totals to match up with the respective columns rather than
displaying them along the top of the page?

Any help would be very muchly appreciated with this.

Thank you.
Dakoris73
 
I guess I should mention that I haven't put any VB code in here as of yet,
and also wanting to know if that is what I'm going to need to do. If that is
the case, can you give me an idea of what kind of VB coding that I am going
to need for this to work and get the columns displayed correctly and in the
correct posistions.

dakoris73
 
Back
Top