Prev: I thought of an easier method - works great
Next: Only show a subreport under certain circumstances?
From: Gina Whipp on 4 Feb 2010 19:56
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

"Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
news:041E5951-9C17-4D2A-AE3F-7201C650B9FB(a)microsoft.com...
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: Steve on 5 Feb 2010 11:12
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
santus(a)penn.com


"Ace MJ Waldor" <AceMJWaldor(a)discussions.microsoft.com> wrote in message
news:8E40BFEE-5036-4231-BA79-89D7220A37BA(a)microsoft.com...
> 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
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>


From: StopThisAdvertising on 5 Feb 2010 15:06

"Steve" <notmyemail(a)address.com> schreef in bericht news:%236%234E4npKHA.3948(a)TK2MSFTNGP06.phx.gbl...
> 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.
>

--
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 'helping' 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


First  |  Prev  | 
Pages: 1 2 3
Prev: I thought of an easier method - works great
Next: Only show a subreport under certain circumstances?