a simple query, maybe

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of part numbers. I want to query the table to return a list
of those part numbers whose last character is the letter D.
 
Hello there,

You need a query with a criteria in the Part Number field
of:

*D

Access will change this to Like "*D" for you.

Hope this helps

Judith
 
Hi, John.
I want to query the table to return a list
of those part numbers whose last character is the letter D.
Click to expand...

Try:

SELECT PartNum
FROM MyTable
WHERE (Instr(LEN(Nz(PartNum, "")), Nz(PartNum, ""), "D", 2) > 0);

.... where PartNum is the name of the field that contains the part numbers,
and MyTable is the name of the table.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
Back
Top