Combining operators

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

fgwiii

Hello,

I am trying to combine the two arguments below to produce the value of 28679
from the value of: 063740286797026.

The problem is that I do not recall how to combine the following so that it
will work in the query correctly:

Site: Right([Patient],9) Left([Patient],5)

Thank you for your help!
 
Or simpler use the Mid function if the length your string is consistent in length.
Mid([Patient],7,5)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

KARL said:
Site: Left(Right([Patient],9),5)

fgwiii said:
Hello,

I am trying to combine the two arguments below to produce the value of 28679
from the value of: 063740286797026.

The problem is that I do not recall how to combine the following so that it
will work in the query correctly:

Site: Right([Patient],9) Left([Patient],5)

Thank you for your help!
Click to expand...
Click to expand...
 
Hello,

I am trying to combine the two arguments below to produce the value of 28679
from the value of: 063740286797026.

The problem is that I do not recall how to combine the following so that it
will work in the query correctly:

Site: Right([Patient],9)    Left([Patient],5)

Thank you for your help!
Click to expand...

Neither. Use MID(String, StartPosition, NumberOfCharacters)
 
Back
Top