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

  • Thread starter Thread starter Guest
  • Start date Start date
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

Similar Threads

Union Querry 1
Using Wild Cards in Paramter Querry 2
many querries into report 4
review sql querry 2
how to select any last record in the querry 5
Need a lookup querry 1
Help Me Fix This Querry 1
Help: Need 1 criteria to find many parts of 1 field 3

Back
Top