A
Air-ron
I have a problem:
I have created a database to track the customer counts in the casino I work
in, and I had envisioned using "Send to" to email reports to accounting and
other departments. Unfortunately, I just found out from my boss that they
need the reports in excel file format, with landscape formatting... etc.
I am using a crosstab query to create the report, and I have grouping set up
by machine vendor, so the report looks like this:
Machine Type Date 12AM 2AM 4AM 6AM...
Vendor1 10/27 2 3 4 39 ...
Vendor1 10/28 5 2 1 18...
Vendor2 10/27 5 12 6 3 ...
Vendor2 10/28 5 2 1 18...
You get the idea.
I need pretty much the same format in excel, only when I try and use export
the file, it saves it with the old formatting... How can I save the new file
with the old formatting, or better yet, use send to (or the VBA equivalent)
to send the file with the correct formatting?
Aaron
I have created a database to track the customer counts in the casino I work
in, and I had envisioned using "Send to" to email reports to accounting and
other departments. Unfortunately, I just found out from my boss that they
need the reports in excel file format, with landscape formatting... etc.
I am using a crosstab query to create the report, and I have grouping set up
by machine vendor, so the report looks like this:
Machine Type Date 12AM 2AM 4AM 6AM...
Vendor1 10/27 2 3 4 39 ...
Vendor1 10/28 5 2 1 18...
Vendor2 10/27 5 12 6 3 ...
Vendor2 10/28 5 2 1 18...
You get the idea.
I need pretty much the same format in excel, only when I try and use export
the file, it saves it with the old formatting... How can I save the new file
with the old formatting, or better yet, use send to (or the VBA equivalent)
to send the file with the correct formatting?
Aaron