Question Fields order different when sent to excel

[captgnvr]

D/All

One of the report using a query I have the list of crew as needed.

For example there are fields like name, rank, code, nationality.

But when I click "analyze it with excel" button the field "name" is shifted to after the field "nationality".

But if I click "analyze it with excel" from the query itself then it maintains the same order.

What could be the reason and how to get the data to excel in the same order as the report. pls help.

 

[KenHigg]

I'm guessing the export routine has no way of knowing how and where the fields show up in the report detail section. I would try ordering them in the reports underlying query and see if that fixes it...

 

[Rich]

It's not the direct cause of your problem but you shouldn't have a field called Name,it's a reserved word in Access and can cause problems elsewhere in your db

 

[captgnvr]

D/mr kenhigg and mr. Rich
thnks for the input.

I am unable to fully understand what mr ken is saying about ordering them in the reports. I have already done that in view-sort order.

With reg to Mr. Rich input, I have gone too deep in so many queries with the fiels as 'name' and i fear too many errors will come up if i change the name of the field. Is any way to change the new field name to take effect in about 30 queries, reports etc?

 

[Rich]

I'm sure newer versions of Access allow you to update all references to a field name change, but I'm not sure which versions, I do know that there are 3rd Party applications that will do this though