Date Add

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

I have text box whose record source is a query. I add 36 months to another
field using “TermEnds: DateAdd(“mâ€,36,[DateAppointed]) Works good, but now
instead of 36 months I want to multiply the "Term" field in each record * 12,
and have that result replace the 36.
 
Back
Top