How to write an access querry to select 12 most digits in a field

K

KARL DEWEY

You seem to have omitted some word(s) in your sentence.
Did you mean LEFT most? Left([YourField], 12)
Did you mean RIGHT most? Right([YourField], 12)
Did you mean most often? Use a totals query with sort order of count
as descinding and SELECT TOP 12.
 

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

Top