Why does layout of Table keep changing. Access 2003

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

Guest

OK, I'll admit that i'm new to Access. been planning the database for quite
a while and finally got the time and nerve to have a go.

Have set up a table of clients including mailing name and address, phone
etc. Originally data was in Act and i exported as .csv then imported into
Access.

My problem is that Access keeps sorting the data in a certain way. I want
the first column to be in alphabetical order and, no matter how many times I
save it after sorting using the A - Z button Access keeps reverting to it's
own format - even when I just click in another column. I can't see any
reason why Access chooses to sort it in the way it does - it's not
alphabetical in any way.

Also, why does the page setup keep reverting to the default - I have tried
to set margins to 10mm all round but Access keeps reverting to 25mm.

Am i missing something really obvious?

Haven't set a primary key yet.

Any advice gratefully received.

thanks
 
Never make any assumptions about the order in which data is stored in
tables. Relational database theory doesn't dictate how records are stored,
so the DBMS puts the data wherever it feels like. The only way to ensure the
order in which the data is presented is to use a query with an appropriate
ORDER BY clause.

It sounds to me as though you're working directly with the tables. You
shouldn't be doing that. You should be using forms to input the data, and
reports to output it.
 
Hi Tony

Don't try and sort the table. The table is just there to store data and not
much else.

Create a query (use the wizard if you want) and sort the columns in the
query how ever you want. Base any forms or reports on this query.

Hope this helps
 
Also, why does the page setup keep reverting to the default - I have tried
to set margins to 10mm all round but Access keeps reverting to 25mm.
Click to expand...

My guess would be that the information Access is getting from the specified
printer driver says that 25mm is the minimum allowed.
 
Back
Top