Select Limited records for a number of criteria

J

Jacko999

Hi all wonder if you can help. I would like to run a query that would enalbe
me to extract a limited number of records for multiple criteria. For example
have a table that has 36,000 postcodes, for each area I want to extract a
certain number of records i.e.

AB = 200 records
AL = 69 records
B = 500 records

I understand how to do this using a single query for each crtieria, but could
really do with a method for doing all at the same time. Any advice really
appreciated!

Cheers

Jacko
 
D

Duane Hookom

How would you do it for a single criteria? I would expect you need some logic
that determines which of the AB records are the 200 selected. Do they have
the minimum values for the ID field? You can't select a subset without
defining how the subset is determined.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print largest number of records first 2
Update Query for only a certain number of records 1
Search the list of Ids in the records 1
Fixed Values in a Query 5
help with syntax for a date range criteria please 3
Highlighting Updated Records 2
How can I query a set of dates but exclude non-working days? 0
Criteria to prompt for field and omit certain records 7

Top