Sorting data in a table

[Guest]

Hello,
I have a table with different customers, customers ID's and products.
Some customers have the same Products.
If I look at the table the data is mixed.
How can I sort the data by customer ID?
Many thanks in advance
Klaus

 

[Al Camp]

While viewing the table, Right-Click the column header you want to sort,
and select sort (Ascending or Descending). Close the table, and save the
design changes. When you reopen the table that coulumn should be sorted.
Actually, the sort order of the table itself is not necessary. You can
always sort it any way you want when you build a query, or a query behind a
form or report. Of course, no users should ever see, or have access to, the
table anyway...

 

[BruceM]

Make a query based on the table. In the query design grid, make a choice in
the Sort row in the CustomerID field. Use a form or report to view the data
rather than looking directly at the query or table.
By the way, if you have Customers and Products in the same table your design
is very likely flawed, and you are not making the most of the capabilities
of Access.

 

[Guest]

Hi Klaus - if all you do is open your table then select the ID column / right
click and choose sort Sort Ascending or Decending. Better to learn to use
queries though, easy to learn and a lot more flexible.