Combining operators

[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!

 

[KARL DEWEY]

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

 

[John Spencer MVP]

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

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

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!

 

[Piet Linden]

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!

Neither. Use MID(String, StartPosition, NumberOfCharacters)