UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> How to alphabetize Field Names in a table    
 
   
Garggle
post Nov 21 2008, 12:16 PM
Post #1

New Member
Posts: 14



Good morning.

I am using Access 2003 and have a table with 200+ fields. I would like to alphabetize the field names to make them easier to find and work with. Can this be done?
Go to the top of the page
 
+
theDBguy
post Nov 21 2008, 12:30 PM
Post #2

Access Wiki and Forums Moderator
Posts: 57,225
From: SoCal, USA



Welcome to Utter Access!

That is a lot of fields! I'm not sure what you mean by finding and working with the fields but you can always create queries to reorder thing in Access.

Can you explain a bit more of what you are actually having problems with?


--------------------
Go to the top of the page
 
+
cpetermann
post Nov 21 2008, 12:33 PM
Post #3

UtterAccess Editor
Posts: 5,184
From: Omaha, NE USA



Welcome to UA! -o!

Your question leads me to believe that you are using Access as a flat spreadsheet
This isn't the correct way to utilize Access.


I would suggest reading through the articles below, and then come back with your questions so we can
help you get your project going on the right foot.sad.gif



Regards,
cynthia


--------------------
Warm regards,
Cynthia

It will all make sense-- when I understand it. And vice versa
"Tell me and I will forget. Teach me and I will remember. Involve me and I will learn!" Ben Franklin
Go to the top of the page
 
+
JVanKirk
post Nov 21 2008, 12:59 PM
Post #4

UtterAccess VIP
Posts: 3,877
From: Fort Drum, NY



I second Cynthia response. In my years of building databases I have never seen a table with 200 fields in it that was normalized. Read through some of the links Cynthia provided and if you would like, strip sensitive data out of a copy of your db and post your db here and we can take alook at it and help you get your structure normalized so you can use your db more efficiently.

J

P.S. As for alphabetizing your fields, I don't know of anyway to go about that without manually going down through and moving them up and down to the right order manually :(


--------------------
Jason VanKirk
Ft Drum, NY

"If you would not be forgotten, as soon as your dead and rotten, do something worth writing, or write something worth reading." - Benjamin Franklin
Go to the top of the page
 
+
Garggle
post Nov 24 2008, 04:03 PM
Post #5

New Member
Posts: 14



Thanks for the welcome everybody.

I'm actually involved in two projects right now. My day job involves the maintenance of a large legacy system. I am also in the planning stage for a smaller DB for my own use.

This question is re: the legacy system. I actually believe the table to be normalized, but will read over the articles you suggest and make sure. Either way the table should probably be split up, but I don't see that happening at the moment. It's too firmly established and there are too many other projects on the burner. Given the size of the table I was hoping to reorganize the fields so that I can find them more easily. I will probably either live with the situation or do what Jason suggests and sort the fields by hand.

As an aside, my other project is a DB to support a Community Supported Agriculture (CSA) garden that I have started as a side business. That project is being a lot of fun.

Thanks,

Allan
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 24th July 2014 - 12:07 PM