By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

Rearranging columns

P: 98
Could Rearranging columns on a table, effect other areas of the database such as reports and queries?
Feb 10 '09 #1
Share this Question
Share on Google+
8 Replies

Expert 100+
P: 375
The simple answer is NO.
Feb 10 '09 #2

P: 98
i figured, just needed someone smarter than me to confirm.

Thank you!!!
Feb 10 '09 #3

Expert 100+
P: 375
You're welcome, but I don't know about the smarter bit. Older maybe. ;)
Feb 10 '09 #4

Expert 100+
P: 1,287
No one very old would have an awesome Doom avatar. But a gamer I work with said yesterday he had never realized Doom was a game and I almost cried.
Feb 10 '09 #5

Expert 100+
P: 375
...and someone told me the other day that Paul McCartney was in a group before he started Wings.
Feb 10 '09 #6

P: 675
Yeah, I remember seeing that other group when they were first on "The Ed Sullivan Show". Lots of yelling from audience.
Feb 11 '09 #7

Expert 100+
P: 375
Me too! You've got me by 4 years.
Feb 11 '09 #8

Expert Mod 15k+
P: 31,419
I wasn't very old at the time ;)

As to the original question - The only change that would be visible after changing the column order would be selecting * in a query. Even then, the only difference would be that the columns displayed in the new order found in the table.

Forms and reports all refer to fields explicitly by name, so their order is not significant.
Feb 16 '09 #9

Post your reply

Sign in to post your reply or Sign up for a free account.