Min Max Mean In Access 2000

[ElmoFringby30]

I have a figure (Ex: 45 +/- 5 ), how can I have this come out on a query or report as: 40, 45, and 50.

 

[jmshik]

Elmo,
If I am understanding you correctly:

SELECT field
from table
WHERE field between 40 AND 50

Is this what you are asking?
jm

 

[ElmoFringby30]

Sorry, the (45 +/- 5) is an example of one column of data, which would be hundreds of lines long (with different numbers). I would like Access to read this (45 +/- 5) and place it in 3 new columns to show 40, 45, 50. The name of the columns would be Min Mean and Max.
Thank you for your help.

 

[ElmoFringby30]

Sorry, the (45 +/- 5) is an example of one column of data, which would be hundreds of lines long (with different numbers). I would like Access to read this (45 +/- 5) and place it in 3 new columns to show 40, 45, 50. The name of the columns would be Min Mean and Max.
Thank you for your help.
Elmo

 

[caltman]

This may be a bit clunky, but it seems to work -

If the name of the column were Value enter the following into the Query grid (in separate columns):

Column1: Int(Left([Value],InStr([Value]," &quot-1))-Int(Right([Value],Len([value])-InStr(InStr([Value]," &quot+1,[Value]," &quot)) AS [Min]

Column2: Int(Left([Value],InStr([Value]," &quot-1)) AS [Mean]

Column3: Int(Left([Value],InStr([Value]," &quot-1))+Int(Right([Value],Len([Value])-InStr(InStr([Value]," &quot+1,[Value]," &quot)) AS [Max]