Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Access hints and tips » Random sampling
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.
Added by Meenesh on 23rd October 2006
More Access hints and tips, like:
 |
|
» Forum post: Macros |
How do you create macros?
