update query: calc w/number fields updating text field

[Guest]

I have have 2 number fields representing months that I want to calc into
years & concatenate into a text field. I get "data type mismatch" on running
something like this:
Update To: ([mo1]/12) &"/" & (([mo2]-[mo1])/12) - the field being updated is
text.

For example:
If mo1 = 36 & mo2 = 360, then text = 3/27

 

[Guest]

Nevermind - I was mis-using the Cstr option at first

 

[Jeff L]

i believe you have to convert your numeric values to text first. Try
this:
Update To: Trim(Str([mo1]/12)) &"/" & Trim(Str(([mo2]-[mo1])/12))