Need a report to print fields in Excel in a certain order

  • Thread starter Thread starter Ace MJ Waldor
  • Start date Start date
A

Ace MJ Waldor

I've got a client that needs the data we collect to show up in a certain
order in an excel speadsheet. Instead of my having to rewrite and
reorganized the form that the data is collected I'd like to know if there's a
way for me to export the data in the order they want to see it. Can this be
done using the report tab from access? and if it can how do I go about to do
it? Just to let you know I'm not that experienced in programming and stuff
so I'll need step by step directions. Thanks for your help in advance.

Ace MJ Waldor
 
How are you exporting the data to the client? Text file, Excel or what?

Steve
(e-mail address removed)
 
Ace MJ Waldor,

You could create a query that displays the data in the order in which you
want it to appear and export the query. OR is the report in a format that
needs to be preserved?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I've got a client that needs the data we collect to show up in a certain
order in an excel speadsheet. Instead of my having to rewrite and
reorganized the form that the data is collected I'd like to know if there's
a
way for me to export the data in the order they want to see it. Can this be
done using the report tab from access? and if it can how do I go about to do
it? Just to let you know I'm not that experienced in programming and stuff
so I'll need step by step directions. Thanks for your help in advance.

Ace MJ Waldor
 
The information is being exported to excel, they're able to import that to
their program which I don't have (ACT!) nor am I interested in getting. So
the reprot needs to be exported in excel in the order that they want to see
the data.
 
As long as the data ends up in an excel format I don't think that it really
matters. I'm just trying to make sure that when the data (or report) comes
out its in the desired format with the fields in the order that they want.
 
Create a query that puts your data in the order you want then export the
query to Excel.

Steve
 
Ace MJ Waldor,

Can you create a query that gives you the desired order you want?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

As long as the data ends up in an excel format I don't think that it really
matters. I'm just trying to make sure that when the data (or report) comes
out its in the desired format with the fields in the order that they want.
 
Not sure, I think I can but the report must be in the excel format and I'm
not sure how to get that done. That's what I'm aiming at, once I know how to
get a report to go out in the excel format I'm sure that the order of the
data can be set up so that it matches the order the client wants.
 
Well that's where the problem (for me at least) lays, how can I get the query
to put it in the excel format.
 
Ace MJ Waldor,

You can export a query, just like a report, to Excel format. Using a query
allows you to put the columns in any order you want and retain that order.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Not sure, I think I can but the report must be in the excel format and I'm
not sure how to get that done. That's what I'm aiming at, once I know how
to
get a report to go out in the excel format I'm sure that the order of the
data can be set up so that it matches the order the client wants.
 
Look at the TransferSpreadsheet function in the Help file. The
TransferSpreadsheet function will allow you to export the records returned
by a query to a specified Excel worksheet. You can then send the Excel file
to the client.

Steve
(e-mail address removed)
 
Back
Top