A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Move a field when exporting into Excel



 
 
Thread Tools Display Modes
  #1  
Old July 20th, 2007, 02:54 PM posted to microsoft.public.access.reports
Stockwell43
external usenet poster
 
Posts: 579
Default Move a field when exporting into Excel

Hello,

I have a question about the way my report is exporting. Everything works
fine and all the data exports. However, for some reason the Address field is
exporting after the State field and the manager wants it to be before the
City. In my report it lined up correctly and also in the query, form and
table the address comes before the City but when exporting it's coming out
after State.

Is there any way to fix this within Access so it exports correctly?
Otherwise, I'll have them correct it in Excel.

Thanks!!!!
  #2  
Old July 20th, 2007, 03:36 PM posted to microsoft.public.access.reports
Carl Rapson
external usenet poster
 
Posts: 517
Default Move a field when exporting into Excel

"Stockwell43" wrote in message
...
Hello,

I have a question about the way my report is exporting. Everything works
fine and all the data exports. However, for some reason the Address field
is
exporting after the State field and the manager wants it to be before the
City. In my report it lined up correctly and also in the query, form and
table the address comes before the City but when exporting it's coming out
after State.

Is there any way to fix this within Access so it exports correctly?
Otherwise, I'll have them correct it in Excel.

Thanks!!!!


Could the report be exporting the fields in tab order? Check the tab orders
of the fields on the report and see if they match the order in the export.
If so, change the tab order to be the way you want it in the export.

Carl Rapson


  #3  
Old July 20th, 2007, 04:00 PM posted to microsoft.public.access.reports
Stockwell43
external usenet poster
 
Posts: 579
Default Move a field when exporting into Excel

Hi Carl,

I didn't see a Tab Control on the fields for the report. However, I did tab
from one field to the next and it does tab in order Adress, City, State and
Zip. I just don't know why that address field comes out that way. Any other
suggesting?

"Carl Rapson" wrote:

"Stockwell43" wrote in message
...
Hello,

I have a question about the way my report is exporting. Everything works
fine and all the data exports. However, for some reason the Address field
is
exporting after the State field and the manager wants it to be before the
City. In my report it lined up correctly and also in the query, form and
table the address comes before the City but when exporting it's coming out
after State.

Is there any way to fix this within Access so it exports correctly?
Otherwise, I'll have them correct it in Excel.

Thanks!!!!


Could the report be exporting the fields in tab order? Check the tab orders
of the fields on the report and see if they match the order in the export.
If so, change the tab order to be the way you want it in the export.

Carl Rapson



  #4  
Old July 20th, 2007, 05:33 PM posted to microsoft.public.access.reports
krissco
external usenet poster
 
Posts: 167
Default Move a field when exporting into Excel

Check to see if the placement of your controls needs fine tuning.
Design the report and click on Properties of each of the controls you
are interested in. I suspect that Address has a slightly lower "Top"
than the other controls.

-Kris

  #5  
Old July 20th, 2007, 06:02 PM posted to microsoft.public.access.reports
Stockwell43
external usenet poster
 
Posts: 579
Default Move a field when exporting into Excel

Hi Kris,

That was it!

Amazing, I would have never thought about that? Excellent piece of reference
going forward. I've looked all though the database and couldn't find anything
wrong and was baffled as to why this is happening.

Thank you very much for your help, your knowledge is greatly appreciated!!!!

Have a great weekend!!

"krissco" wrote:

Check to see if the placement of your controls needs fine tuning.
Design the report and click on Properties of each of the controls you
are interested in. I suspect that Address has a slightly lower "Top"
than the other controls.

-Kris


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.