Selecting Values with the Letter P

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

Guest

Hello,
I have a query that contains a text filed will all the project codes of the
clients we deal with. Most of them are three digit numbers (I.e. 707, 708,
709). However, if we are writing a proposal we stick the letter P before the
three digit code (i.e. P707, P708, etc). Therefore I was wondering if there a
string I could put in the criteria that would allow me to only select
proposals (i.e. records containing the letter P).

thanks in advance,
 

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

Deriving Client Code as Default Value 6
Formula for adding values that have a letter at the end in Excel 2 3
Query Dcount with multiple conditions 3
Dynamic Creation of Invoice number 23
String with Varying Letter followed by Incremented Number 3
Search 1
How do I count the cells ending with a specific letter? 5
Help with CountIF formula 3

Back
Top