Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft database training - vertical numbers

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

microsoft database training - Vertical numbers

ResolvedVersion Standard

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.?

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.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.