Prev: I thought of an easier method - works great
Next: Only show a subreport under certain circumstances?
From: Ace MJ Waldor on 3 Feb 2010 19:17
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
--
Your One Stop Public Records Research Group
From: Steve on 3 Feb 2010 19:37
How are you exporting the data to the client? Text file, Excel or what?

Steve
santus(a)penn.com


"Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
news:71FF4CAD-EBB4-443C-8439-211A11AD37AD(a)microsoft.com...
> 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
> --
> Your One Stop Public Records Research Group


From: Gina Whipp on 3 Feb 2010 20:19
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

"Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
news:71FF4CAD-EBB4-443C-8439-211A11AD37AD(a)microsoft.com...
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
--
Your One Stop Public Records Research Group


From: Ace MJ Waldor on 3 Feb 2010 21:48
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.
--
Your One Stop Public Records Research Group


"Steve" wrote:

> How are you exporting the data to the client? Text file, Excel or what?
>
> Steve
> santus(a)penn.com
>
>
> "Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
> news:71FF4CAD-EBB4-443C-8439-211A11AD37AD(a)microsoft.com...
> > 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
> > --
> > Your One Stop Public Records Research Group
>
>
> .
>
From: Ace MJ Waldor on 3 Feb 2010 21:51
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.
--
Your One Stop Public Records Research Group


"Gina Whipp" wrote:

> 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
>
> "Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
> news:71FF4CAD-EBB4-443C-8439-211A11AD37AD(a)microsoft.com...
> 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
> --
> Your One Stop Public Records Research Group
>
>
> .
>
 |  Next  |  Last
Pages: 1 2 3
Prev: I thought of an easier method - works great
Next: Only show a subreport under certain circumstances?