You are here:

Using MS Access/selecting specific enteries in Access


Any help would be really great!

I have an access database where I have one column containing a location ID, and another column containing a value (corresponding to the location). So say Col A (location id) and Col B (value). The location IDs are unique identifiers something like, NW-01-01, NW-01-02, SE-03-05,SE-04-02.

There are over 2000 data entries. I was asked to provide the value (in Col B) for 80 random site IDs (column A). Someone told me that I can do a calculation in Access (or via export to excel) whereby I do not have to manually find each individual location ID and the value.  

However since each location ID is a unique 6-character label and they have randomly asked for 80, I think it is not possible to do. That is, don't I need some criteria to be able to query or sort that.

Thank you in advance

You're right, trying to select random records with this table would be very difficult if not impossible. But the solution is simple, add an outnumber field to the table and generate 80 random numbers within the range. If you can't modify the table, create a temp table with an outnumber and run an append query.

Hope this helps,

Using MS Access

All Answers

Answers by Expert:

Ask Experts




I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.


I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Brooklyn College BA

©2017 All rights reserved.

[an error occurred while processing this directive]