Sort table data as entered?

[mud2]

My continuing fight with ACCESS: How (can I !) do I get a table sorted after I enter data? The data is numerical. If I "access" the table after I save it, click on the column I want sorted, and chose sort, the table does sort, but ONLY visablly. If I "access" the table and print out the records, they appear as I originally entered them!
Yes. I can do a make table (sorted) query, and that made table IS sorted. But I want to use the original table...I suppose I could make-table-sort to a temporary tabe, and then copy it to the original table...but what mickey mouse!

[OBP]

Sorting for output is the province of Queries (amongst other things) so why not use them as designed?
Therefore Tables do not need to be sorted (Unlike Excel).

[CreganTur]

I agree with Tony- you should never rely on your table to organize your data for you. Tables weren't designed to do that, they're just repositories for your data. This is why there are OrderBy and GroupBy functions in SQL- so you can arrange your data for output.