Access moving order of fields

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
capabel Members Profile Find Members Posts Newbie Joined: 14 January 2005 Status: Offline Points: 1	Post Options Post Reply Quote capabel Report Post Thanks(0) Quote Reply Topic: Access moving order of fields 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.

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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.

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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
	Blog \| MPG Tracker

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.