Re: re-order feilds in existing database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



On Thu, 15 Jan 2009 13:50:42 -0500, Mark Kubicki wrote:

I've got a couple of append queries where both tables have the same
fields...,except one of the tables has them in a different order than the
other. Being fussy, I'm sure, but... is there a way to re-order fields in
an existing table?
Or does it really matter, and should I stop worrying about stuff like this?

thanks in advance,
mark

Be thankful if this is the biggest worry you have.
Forget about it. It doesn't matter what the order is.

However, if it's going to keep you up at night you can open one of the
tables in design view and select the row you wish to move and just
drag the field into the order you wish.
Open the table. If the table appears in the new order you're done. If
a field is still out of order, click on the field caption so you
highlight the entire row. Place your cursor over the caption and
left-click and drag to column where you want it.

See paragraph #1.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.



Relevant Pages

  • Re: The electron is not a point.
    ... push, would also be enough to generate drag, with results that would ... by all the other matter. ... The matter absorbs at certain frequencies ...
    (sci.physics)
  • Re: A vertically integrated company should do better
    ... other than for you to deny and to accuse me of being as ignorant as you. ... understand the motivation for utilizing drag and drop. ... This works in Snow Leopard at least. ... No matter how you slice it, ...
    (comp.sys.mac.advocacy)
  • Black Holes" are vortices which CREATE surrounding star structure.
    ... set by Einstein's theory of relativity, which means that they can drag ... The near lightspeed spin of space in these ... spins them up into matter. ...
    (sci.physics)
  • Re: P*ss on em
    ... What a drag. ... no matter how "loyal" we think our ... refused to work anymore; ... ex-employee who was willing to help out - but it took them two weeks to ...
    (sci.med.transcription)