I want to update a table

[Guest]

Hi,

What I want to do seems pretty staight forward but in Access is seems so
cumbersom. I cant understand why - I must be doing something wrong.

I have a table = "TableA". With 10 columns and ~1500 rows. All I want to
do is sort by Column 1 Ascending and then Column 2 ascending. AND REPLACE
THE TABLE. I want to do this automatically in the query, because I have a
series of queries.

But when I do a "Make Table Query" I cannot name the table "TableA". This
seems really cumbersome because I have to rename another table, taking up
more space. Is access this dumb or is it just me?

Thanks for your help.

 

[Guest]

Hi Jeff

I'm a little lost with this. You want to rename a table to the same name as
another table?. This must be wrong. Can you re-word the question - although
some one else may able to understand it better.

 

[Guest]

Sure - I can make the problem easier to follow.

I have a table with one column. The values are 1,3,4,2.5 in that order.

I want to reorder the values so that they go in ascending order. That would
be
1, 2.5,3,4

I can click on the "AtoZ" to order this. But I want to do this
automatically and I dont want to create another table because this wastes
space. How is this done?

 

[Guest]

Sure,

Suppose I have a table with one column and the values in each row is

1,4,3,2

I want to reorder the values so that they are in ascending order.

1,2,3,4

I can do this by clicking on the "AtoZ".

How do I do this automatically as part of the query without creating another
table.

Thanks

 

[Guest]

Why do you need to create another table?
If you can create a query that return the right order, then use this query
instead of creating a new table based on that query.

Select * from TableName Order By AtoZ

 

[Guest]

Hi jeff

Have a look at the post by Offer.

If you think about the tables as just somewhere to store data (and a very
few other tasks) then you will be on the right lines. Tables are not for
working on by users. You should use forms and queries for most of the user
based actions.

Good luck

 

[John W. Vinson]

I must be doing something wrong.

You are: assuming that a table has an order. It doesn't.

A table is an unordered "heap" of records. It will - usually - be displayed in
primary key order, but there's no guarantee even of that!

If you want to see records sorted in a particular order, leave the table
alone, and create a Query based on the table; specify the sort order in this
Query. The Query can be used as the recordsource for a form or report, it can
be edited, it can be exported - you can do anything with the query that you
can do with the table.

John W. Vinson [MVP]