Prev: I thought of an easier method - works great
Next: Only show a subreport under certain circumstances?
From: StopThisAdvertising on 4 Feb 2010 03:20

"Steve" <notmyemail(a)address.com> schreef in bericht news:eR7eAJTpKHA.1552(a)TK2MSFTNGP04.phx.gbl...
> How are you exporting the data to the client? Text file, Excel or what?
>

--
I 'promised' you to hunt each and every post Steve....
Again.... It won't work but that 's no problem... it's a shame...

Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.000 pageloads... it's a shame !!)

For those who don't 'agree' with this mail , because $teve was 'helpfull' with his post...
We warned him a thousand times... Sad, but he is not willing to stop advertising...

He is just toying with these groups... advertising like hell... on and on... for years...
oh yes... and sometimes he answers questions... indeed...
and sometimes good souls here give him credit for that...

==> We are totally 'finished' with $teve now...
==> Killfile 'StopThisAdvertising' and you won't see these mails....

Arno R


From: Steve on 4 Feb 2010 12:15
Create a query that puts your data in the order you want then export the
query to Excel.

Steve


"Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
news:71D08B5B-13BA-4C1E-AFF1-17D8056DB143(a)microsoft.com...
> 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: Gina Whipp on 4 Feb 2010 13:05
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

"Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
news:314846E1-F342-4EEC-B8DD-3ACF5D7D6F6E(a)microsoft.com...
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
>
>
> .
>


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


"Gina Whipp" wrote:

> 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
>
> "Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
> news:314846E1-F342-4EEC-B8DD-3ACF5D7D6F6E(a)microsoft.com...
> 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
> >
> >
> > .
> >
>
>
> .
>
From: Ace MJ Waldor on 4 Feb 2010 18:20
Well that's where the problem (for me at least) lays, how can I get the query
to put it in the excel format.
--
Your One Stop Public Records Research Group


"Steve" wrote:

> Create a query that puts your data in the order you want then export the
> query to Excel.
>
> Steve
>
>
> "Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
> news:71D08B5B-13BA-4C1E-AFF1-17D8056DB143(a)microsoft.com...
> > 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
> >>
> >>
> >> .
> >>
>
>
> .
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: I thought of an easier method - works great
Next: Only show a subreport under certain circumstances?