update query: calc w/number fields updating text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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))
 
Back
Top