Displaying text when a number is <0.1

[badmem]

Is it possible to display the letter "M" if a number is <0.1. I have a field that subtracts one number from another. If the result is <0.1I would like to store the calculated number but display a note to show that the result is less than the detecable limit. Thank you.

[JoeM]

I would recommend using a calculated field separate from the calculation (it is usually not a good idea to mix data types in a single field in a database).

So you have your own field doing your subtraction like this:

Calc1: [Field1] - [Field2]

and you could have a second calculated field like this:

Calc2: IIF([Field1] - [Field2] < 0.1, "M", "")

[cyanidem]

Where would you like to display that "M" letter? On a label next to it? Store it in another field? Are we talking about form or table?
On the form I would put this in OnCurrent event:

If Me.NumberField < 0.1 Then
    Me.NoteLabel.Caption = "M"
Else
    MeNoteLabel.Caption = ""
End If