How to query this?

  • Thread starter Thread starter Song Su
  • Start date Start date
S

Song Su

My field like this:

ART 201
BSICKL 020C
PHYS ED 230
CE ESL 043CE

So the first part contain upto 7 characters, followed by a space, then 3
digit number with optional 1 or 2 character.

I want my result for only first part to be like:

ART
BSICKL
PHYS ED
CE ESL

Thanks.
 
Thanks. It works perfectly.

KARL DEWEY said:
Try this --
Some_Name: Left([YourField], InStrRev([YourField], " ") -1)
--
KARL DEWEY
Build a little - Test a little


Song Su said:
My field like this:

ART 201
BSICKL 020C
PHYS ED 230
CE ESL 043CE

So the first part contain upto 7 characters, followed by a space, then 3
digit number with optional 1 or 2 character.

I want my result for only first part to be like:

ART
BSICKL
PHYS ED
CE ESL

Thanks.
Click to expand...
Click to expand...
 

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

How to tell a subform what data to display... 3
Need help sorting a self join query 4
Remove Certain String from Query Field 6
Help with a partial match query 6
SQL query to XML 2
Combine Two Queries in Different Layouts 2
QUERY METHOD 9
Help needed on zero filling the left and middle and concatenate 0

Back
Top