Query Help Please

[Mike]

I a RegisterZ report that combines all these notes into one field. How can I
seperate
the notes into there own field. I'm really only needing the Tax.
VISA $662.13‡MC $ 112.04‡TAX $157.34‡SAFE $500.00‡RJR $45.00‡PM $ 4.00‡S & M
$2.00‡STORE COUP $2.00‡CUST COUNT 166

Any help would be great

 

[Ken Snell \(MVP\)]

You can parse out the portion of the text string that contains the TAX info:

JustTheTaxInfo: Mid(Left([FieldName],InStr(InStr(1,[FieldName],"TAX
",1),[FieldName],"?",1)-1),InStr(1,[FieldName],"TAX ",1))

 

[Mike]

I'm getting a #Error

Im not sure why my message in your reply shows ? and in my main post is
something else. Im not sure of the symbol( ‡‡ ) in my main post but Im
guessing
it must be spaces? Any other Ideas

You can parse out the portion of the text string that contains the TAX info:

JustTheTaxInfo: Mid(Left([FieldName],InStr(InStr(1,[FieldName],"TAX
",1),[FieldName],"?",1)-1),InStr(1,[FieldName],"TAX ",1))

--

Ken Snell
<MS ACCESS MVP>

I a RegisterZ report that combines all these notes into one field. How can
I
seperate
the notes into there own field. I'm really only needing the Tax.
VISA $662.13?MC $ 112.04?TAX $157.34?SAFE $500.00?RJR $45.00?PM $ 4.00?S &
M
$2.00?STORE COUP $2.00?CUST COUNT 166

Any help would be great

 

[Mike]

Ok
I removed the "?" and have replaced with " " and gets some of the Tax for
one space.

You can parse out the portion of the text string that contains the TAX info:

JustTheTaxInfo: Mid(Left([FieldName],InStr(InStr(1,[FieldName],"TAX
",1),[FieldName],"?",1)-1),InStr(1,[FieldName],"TAX ",1))

--

Ken Snell
<MS ACCESS MVP>

I a RegisterZ report that combines all these notes into one field. How can
I
seperate
the notes into there own field. I'm really only needing the Tax.
VISA $662.13?MC $ 112.04?TAX $157.34?SAFE $500.00?RJR $45.00?PM $ 4.00?S &
M
$2.00?STORE COUP $2.00?CUST COUNT 166

Any help would be great

 

[Ken Snell \(MVP\)]

The ? symbol that I was using as the delimiter came from your original post.
To make the expression work that I'd provided, you need to replace the "?"
with the correct delimiter character (surrounded by " characters) -- the one
that separates the different notes in the one field.

--

Ken Snell
<MS ACCESS MVP>

Ok
I removed the "?" and have replaced with " " and gets some of the Tax for
one space.

You can parse out the portion of the text string that contains the TAX
info:

JustTheTaxInfo: Mid(Left([FieldName],InStr(InStr(1,[FieldName],"TAX
",1),[FieldName],"?",1)-1),InStr(1,[FieldName],"TAX ",1))

--

Ken Snell
<MS ACCESS MVP>

I a RegisterZ report that combines all these notes into one field. How
can
I
seperate
the notes into there own field. I'm really only needing the Tax.
VISA $662.13?MC $ 112.04?TAX $157.34?SAFE $500.00?RJR $45.00?PM $
4.00?S &
M
$2.00?STORE COUP $2.00?CUST COUNT 166

Any help would be great