Need help to find Values after from

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

This what a snippit of what my field COMMENT looks like.
I would like to be able to get the difference of the from to
Thanks for any help.

00033300718160: from $86.990 to $91.550
033300611072: from $25.650 to $25.450
050545220203: from $4.250 to $4.250
 
First Value can be calculated with
Val(Mid([Comments],Instr(1,[Comments],"from $",1)+6))

Second value can be calculated with
Val(Mid([Comments],Instr(1,[Comments],"to $",1)+3))

Difference is computed by subtracting the two values.

As long as Comments is not null I think this should work for you. It does
rely on the data entry being consistent.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top