Alphabetical Table Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The tables that I am developing queries have many fields. I would like to be
able to have the fields show up in alphabetical order when I am designing a
query. Is this possible? Ideally I could toggle back and forth easily.
 
The tables that I am developing queries have many fields. I would like to be
able to have the fields show up in alphabetical order when I am designing a
query. Is this possible? Ideally I could toggle back and forth easily.
Click to expand...

The order of fields in a table is arbitrary; you can go into table
design and move the fields up and down as you wish. They should appear
in that order in the query design window.

I have to be a bit concerned: 30 fields is a wide table; 60 fields is
an ENORMOUSLY wide table. If your tables are wider than this, you may
need to step back and think about normalizing your table structure
(for this and for many other reasons!)

John W. Vinson[MVP]
 
I with that I could normalize the database, but this is a commercial ERP
system and I don't really have control over that.
Thanks for the response.
 
Back
Top