Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft database training - Vertical numbers

microsoft database training - Vertical numbers

ResolvedVersion Standard

Mon 3 Dec 2007, 13:22 Delegate Sunette said...

Sunette has attended:
Excel Intermediate course

Vertical numbers

How do I sort my spreadsheet numbers if they are all in the wrong order. Is there a way that I can do this without having to type 1 - 20 etc in each new row.?

Tue 4 Dec 2007, 09:51 Trainer Amanda said...

RE: vertical numbers

Hi Sunette

Thank you for your question.

You can sort information in a spreadsheet provided that each column of data has a heading that you have typed in, and that there are no blank rows or blank columns within the data.

For example, if you had a column with the heading Number, you can select a cell in this column and click Sort Ascending to sort from the lowest number to the highest number.

I hope this helps.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

microsoft database training - Vertical numbers

Vertical numbers

RE: vertical numbers

Access articles

Access tip:

Random sampling