Rearranging columns

[trixxnixon]

Could Rearranging columns on a table, effect other areas of the database such as reports and queries?

[RuralGuy]

The simple answer is NO.

[trixxnixon]

The simple answer is NO.

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


Thank you!!!

[RuralGuy]

You're welcome, but I don't know about the smarter bit. Older maybe. ;)

[ChipR]

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.

[RuralGuy]

...and someone told me the other day that Paul McCartney was in a group before he started Wings.

[OldBirdman]

Yeah, I remember seeing that other group when they were first on "The Ed Sullivan Show". Lots of yelling from audience.
OldBirdman

[RuralGuy]

Me too! You've got me by 4 years.

[NeoPa]

Yeah, I remember seeing that other group when they were first on "The Ed Sullivan Show". Lots of yelling from audience.
OldBirdman

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.