Database Discussion - Access moving order of fields

Print Page | Close Window

Access moving order of fields

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13360
Printed Date: 30 March 2026 at 2:33am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access moving order of fields

Posted By: capabel
Subject: Access moving order of fields
Date Posted: 14 January 2005 at 8:18pm

I know this is probably a simple fix but here it goes.

I'm working on a simple database and wanted to move a field on the far left to show as the first field in a table. Basically I created the entry last and outside of deleting and recreating the field is there a way to just move it to the far left to show first?

Any and all help is appreciated.

Replies:

Posted By: dj air
Date Posted: 15 January 2005 at 6:46am

what type of database is this , access, MSSQL, MySQL?

if access or MSSQL as i know them.

open them in desing view and select the collimn line. and cut, then go to the top and right click on the side bar and select instert new and then right click on the new /blank line and paste.

Posted By: michael
Date Posted: 15 January 2005 at 12:58pm

Or just don't worry about it and change the select order like

Select f5,f1,f2,f3,f4 from t

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker